Forms - How to link them

[Don2k7]

I've got two tables Customers and Repairs they are related by CustomerID field in the customers table and the CustomerID field in the Repair table.

I'm trying to create a Form to show customers and their orders both in form view everytime i use access to do this it makes the Customers into a nice form but the Repair table comes up as a table.

The database needs to book in Repairs for Customers.

If i havnt explained anything or it does not make sense just quote me and ill reply , im on all night.

 

[boblarson]

The default view for a subform is a datasheet view which LOOKS like a table but isn't. Anyway, you can change that by opening the subform itself (after it has been created) and go to the properties dialog and then find DEFAULT VIEW in the ALL tab and you can change it to continuous or Single form view.

 

[Don2k7]

The default view for a subform is a datasheet view which LOOKS like a table but isn't. Anyway, you can change that by opening the subform itself (after it has been created) and go to the properties dialog and then find DEFAULT VIEW in the ALL tab and you can change it to continuous or Single form view.

Your a good looking chap , and you just helped me solve a problem that has been troubling me for a long long long long long long long time!!!!

THANK YOU SO MUCH!!!! YOU ARE GREAT!!

 

[boblarson]