I have create a customer database, my tables consist of customers, contact numbers and 08 numbers.
I want to create a relationship from the customer table to the contact number table and again from the customer table to the 08 number table.
Is this possible?
If so how do I go about doing it?
Thanks
Problem solved.
After much searching I went into Design view and clicked on properties changed the subdatasheet to NONE and hey presto everything is OK.
Thanks
Well you near enough hit the bulls eye with the response.
I did have a relationship between the two tables but no information at present to go in one and wasnt sure how I wanted it therefore I deleted it to think about it and start again but having deleted it i am now being asked for the...
I have recently setup an access database and am having a problem with the relationships. I created relationships and then deleted a table to which the table did not recognise and it still had the + sign to click on - I have now created the table again but when I click on + I am asked for a...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.