strawberry
Registered User.
- Local time
- Today, 15:22
- Joined
- Apr 1, 2008
- Messages
- 43
Hi, i am creating a new database. here is a brief description
Table 1 - DrawingNoSequence (Primary Key) ie 6054
Supplier
Model
Table 2 - DrawingNoSequence (Primary Key) ie 6054
DrawingNo (Primary Key) ie 1
Revision (Primary Key) ie 0
Date
Title
the relationship between these two tables is the DrawingNoSequence
Table 2 has 3 primary keys to make a unique reference ie. 6054/1/0 or 6054/1/1 or 6054/2/0 for example
The third table i am creating is called customer table and this will
comprise of
Customer Name
Date
DrawingNoSequence/Drawing/Revision ie 6054/1/0
This is the bit i am stuck on. I have created the customer table doing a look up for all 3 fields separately but when i create the form it doesnt seem to work properly
i want to create a customer form where by there is a field which lists a combination of the three primary keys from table 2 where the operator scrolls down to choose which drawing they have. I also am not sure on what relationships need forming between table 2 and customer table
I am guessing that the customer table needs to be created in a particular sort of why in the first place for this to work
I hope someone can point me in the right direction and hope the above makes sense
Many thanks
Table 1 - DrawingNoSequence (Primary Key) ie 6054
Supplier
Model
Table 2 - DrawingNoSequence (Primary Key) ie 6054
DrawingNo (Primary Key) ie 1
Revision (Primary Key) ie 0
Date
Title
the relationship between these two tables is the DrawingNoSequence
Table 2 has 3 primary keys to make a unique reference ie. 6054/1/0 or 6054/1/1 or 6054/2/0 for example
The third table i am creating is called customer table and this will
comprise of
Customer Name
Date
DrawingNoSequence/Drawing/Revision ie 6054/1/0
This is the bit i am stuck on. I have created the customer table doing a look up for all 3 fields separately but when i create the form it doesnt seem to work properly
i want to create a customer form where by there is a field which lists a combination of the three primary keys from table 2 where the operator scrolls down to choose which drawing they have. I also am not sure on what relationships need forming between table 2 and customer table
I am guessing that the customer table needs to be created in a particular sort of why in the first place for this to work
I hope someone can point me in the right direction and hope the above makes sense
Many thanks