I don't know if what I am trying to do is possible. I have 4 tables:
Table 1 - Contains customer information.
Table 2 - Contains Warranty information
Warranty ticket number (autonumber)
Customer ID (lookup in table 1)
Table 3 - Contains Warranty Repair for a cetain type of repair. For example workstation repairs. Included in this table is the warranty ticket number and the various types of repairs.
Table 4 - Same as table 3 but for a different type of repair. For example notebook repairs. Included in this table is the warranty ticket number and the various types of repairs.
Form 1 - Input customer data (table 1)
Form 2 - Inputs data into tables 2 & 3.
Form 3 - Inputs data into tables 2 & 4.
In order to input data on forms 2, 3 & 4, the tables must be linked. If I link the tables via warranty ticket number (autonumber)it doesn't work. If I change the warranty ticket number from autonumber to text (table 2)and manually input the warranty ticket number, the form works. I then left the warranty ticket number autonumber and link tables 2, 3 and 4 via the customer id but it did not work either.
I would appreciate any input. Thanks.
Neup44
Table 1 - Contains customer information.
Table 2 - Contains Warranty information
Warranty ticket number (autonumber)
Customer ID (lookup in table 1)
Table 3 - Contains Warranty Repair for a cetain type of repair. For example workstation repairs. Included in this table is the warranty ticket number and the various types of repairs.
Table 4 - Same as table 3 but for a different type of repair. For example notebook repairs. Included in this table is the warranty ticket number and the various types of repairs.
Form 1 - Input customer data (table 1)
Form 2 - Inputs data into tables 2 & 3.
Form 3 - Inputs data into tables 2 & 4.
In order to input data on forms 2, 3 & 4, the tables must be linked. If I link the tables via warranty ticket number (autonumber)it doesn't work. If I change the warranty ticket number from autonumber to text (table 2)and manually input the warranty ticket number, the form works. I then left the warranty ticket number autonumber and link tables 2, 3 and 4 via the customer id but it did not work either.
I would appreciate any input. Thanks.
Neup44