Many tables need to access one other for reference

[JimHutton]

Hi,

I have several tables in my Access 2000 Database which all need to refer to specific tabel which holds the values for the reference numbers.

I link them all using the relationship, but when i come to opening the table, i get prompted with... Insert Subdatasheet.

I need all the link tables so they are shown here, not just one, how do i do this?

Thanks
Jim

 

[SgtJarrow]

You can only show one linked table in the table window...and actually this should even be an issue. You should not enter data through the table directly. Create a form based off each of the tables and make all the "linked" tables subforms of the main form....then you can display more than one at a time.

****************************
When the human body encounters disease it raises its temperature making it uncomfortable not only for the body but also for the disease. So it global warming the Earth's way of saying we are not wanted?

Robert L. Johnson III
MCSA, CNA, Net+, A+
w: rljohnso@stewart.com
h: wildmage@tampabay.rr.com

 

[willir]

Jim

mstrmage1768 is right -- For the most part, data should be entered through forms, or programatically with a properly written import program. and it is preferable to view data in forms, queries and reports -- again, avoid the table level.

Entering data at the table level can be dangerous.

Richard

 

[JimHutton]

oh right, thankyou for you advice.

Kindest Regards
Jim
-*