Jester1147
Registered User.
- Local time
- Today, 17:44
- Joined
- Mar 27, 2009
- Messages
- 13
First, i want to say thanks for the help i have received so far... its been quite positive. However, i think that due to the circumstances of the type of db i have been asked to construct, i may have found myself backed into a corner. Instead of using dummy terms, i will use the actual names that im using so yall can get an idea of what needs to be figured out.
I have a master table that pretty much stores everything. The PK is titled Serial# (yes, its an asset style db). Now, when ever these assets are issued out to personnel they are required to sign a hand receipt for these items. Obviously with the Serial# there is a Nomenclature that goes with it. Each serial# is then assigned to an individual. Sometimes there comes an event to where one individual can have multiple serial numbers (no more than 2 due to the nature of the asset). Now i have figrued out how to create a query to where the individual's name is shown with all assigned assets, but how do i go about showing BOTH (again no more than 2 assets) Serial#s + Nomenclatures on one form in order (like a datasheet but in the dead center of a form to where the layout of the form remains). There are a series of other fields necessary for this form but ih ave it situated and just need the ability to show the multiple records.
i will try to clear up anything i can. Thanks.
I have a master table that pretty much stores everything. The PK is titled Serial# (yes, its an asset style db). Now, when ever these assets are issued out to personnel they are required to sign a hand receipt for these items. Obviously with the Serial# there is a Nomenclature that goes with it. Each serial# is then assigned to an individual. Sometimes there comes an event to where one individual can have multiple serial numbers (no more than 2 due to the nature of the asset). Now i have figrued out how to create a query to where the individual's name is shown with all assigned assets, but how do i go about showing BOTH (again no more than 2 assets) Serial#s + Nomenclatures on one form in order (like a datasheet but in the dead center of a form to where the layout of the form remains). There are a series of other fields necessary for this form but ih ave it situated and just need the ability to show the multiple records.
i will try to clear up anything i can. Thanks.