Apr 28 2005, 10:04 AM
How do I make it so that when I add a new record to the 'Customers' table my DB will add a record with the same primary key to table 'Jobs'?
It's pretty basic stuff I suppose, but I don't know how. I'm using forms.
Apr 28 2005, 10:08 AM
You may try to use a subform (bound to Jobs) placed on the main form (bound to Customers)
Apr 28 2005, 10:18 AM
That's what I have, but it's not working. I want to allow for more than one job per customer. So CustID could be 66 and that would apply to jobs (JobID) 70 and 71.
Apr 29 2005, 12:31 AM
It should work. You have to have CustID as Foreign key in Job table.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here