Conceptualization question

C

Chel

I have a database similar to that of the Assets example. I want to add a
check in/Check out sheet similar like the one you would see at an apartment
complex. The check in

I created one table that has all of the fields needed in both forms. I'm
really having difficulty conceptualizing where to put the data. The fields on
the form will be the same but the data will be different. Would it be wise to
create each check in/check out sheet on a different tab in the same form?

Anything will be helpful. Thanks for any help offered- For some reason I
have drawn a blank.

Chel
 
P

Pat Hartman

The check out list should be limited to things available for check out. The
check in list should be limited to things already checked out but not
returned. The same form can show both lists either as subforms or tabs or a
single list can be controlled by modifying the selection criteria.

Keeping track of what is in and what is out can be as simple as adding a
checkout date to your items table. But usually, people want more
information such as who checked it out and when it is expected back. That
means you also need a person/customer table so you can keep track of people
and their contact information. And finally, if you want to track history of
the in/out process, you need yet another table which is actually a junction
table between items and people with the added information of out and in
date.
 
C

Chel

Thanks!


Pat Hartman said:
The check out list should be limited to things available for check out. The
check in list should be limited to things already checked out but not
returned. The same form can show both lists either as subforms or tabs or a
single list can be controlled by modifying the selection criteria.

Keeping track of what is in and what is out can be as simple as adding a
checkout date to your items table. But usually, people want more
information such as who checked it out and when it is expected back. That
means you also need a person/customer table so you can keep track of people
and their contact information. And finally, if you want to track history of
the in/out process, you need yet another table which is actually a junction
table between items and people with the added information of out and in
date.
Click to expand...
 
Top