Need help linking fields in access tables together for writeing an estimate. Simple.
Table ? (customerinfo) ? Fields (EstimateID, CustomerID);
Table ( lineitems) ? ? ? ? Fields(EstimateID, ItemID, CustomerID);
I need a way to link customer to there estimates and estamites to the customers . one customer may have several estimates.
## Deliverables
Simply help me link the estimats to there customers and vise versa for writing the estimates.
So when you click new it will create the proper estimateid, customerId etc.....