G'day,



It's been a long time since I have looked at my old database, and I am now trying to add in another table.

Basically my entire database is for a small business. It needs to hold information in regards to customers, Their till repairs, deliveries to customers, and Loan machines that we have sent them.

I don't know the best way to do this, and everytime I try using a table with lookups, I don't get the information to display correctly.

I have 3 tables of information that are required for the Current_Loan table. They are:
Customer
RA
Loan Equipment

What I want to be able to do is:

When I open up the current loan table, I need to be able to select the Loan Till ID, then select the RA number that it corresponds too. I want it then to automatically fill the customer information and the RA information automatically. But I am still required to type this in manually.

As I have not done alot of work with Access before I am not sure if I should create a query that writes this information to a table, or if I should create a form with a subform for the customer and Till repair.

Any suggestions?