Search results

Does your invoice table have a PaymentID field? If so, then you can link to the customer data using the relationship to the invoice table. I would use all three tables as the data source for your form (make a query), and then you should be able to make relationships and show the payment info...

Thank You! That makes so much sense now.

Perhaps I'm looking at the problem the wrong way. So I'll just type out my scenario: Employee 1 currently has Laptop D checked out to them. However, they also have had Laptop A, B, and C in the past. Employee 2 is now using Laptop A, etc. I want to be able to know which laptops are being...

Kryst51, Thanks, but I meant can I have these relationships at the same time? I would use the one-to-many relationship to keep track of what is currently checked out, and then use the many-to-many only for a history.

I am making an inventory database, and I would like to keep a running history of who has had which equipment checked out to them. I already have a one-to-many relationship between the equipment and employee tables. Is is possible to create a many-to-many relationship between the same two...