It sounds like you haven't defined your relationships properly. i.e., Primary key/Secondary key.
For your first table tbl.name should be your Primary key that is linked to your tbl.address. This will be a one-many relationship due to multiple addresses. Then you need to create another table...
I've designed a database that works fine, but I'd like to limit end-users ability to access the database other than what I've already setup in the 'start up' in the Tools menu. I have the viewing database disabled during start up, yet anyone can press the F-11 key and view the database...
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.