Missing Links in tables - help needed please.

[compnet]

Hi Guys

Do you ever wonder if you have bit off more than you can chew.. I have with this. I hope someone can help please.

I have created a db with 5 tables to record a number of order items for a customer with campaign details. My normalisation skills are a little rusty but this was the best I could come up with.

I have created a form using a subform to add/amend customer details (main form) and I can add/amend order details (sub form).

But I am missing the links to the campaign and order batch table. I assume I have to trigger an update with the appropriate data to place in the tables.

I have attached a relationship chart hoping that helps.

To summarise
I can add data to TblOrders and TblCustomers, but my links in TblCustomerOrders and TblBatchOrders are missing - the CampaignID I can get from the main customer form as I can the CustomerID, the CustomersOrdersID will autogenerate when adding data as will the BatchID, but I will need the new CustomersOrdersID for the TblBatchOrders table.

I hope thats clear, sorry am very rusty at this..

I hope somone can help me out please.

Regards
Jerry

 

[PHV]

Have a look here:

http://r937.com/relational.html

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[compnet]

Hey

Thanks....... Didn't I just read these in other posts or am I going mad?

Jerry