Relations in MS Access

[Shiblie Bshara]

I'm trying to Build a Front-End Database for a data entry.

After I made all the tables with it's headers, I was trying to make a
relation between the tables in-order to get a drop-list at some of my sells
at the main table. but whenever I try to make relations, non of the table
contents appear in the box.

is there any thing that I missed??
Thanks in advance
Regards,
Shiblie.B

 

[boblarson]

More learning for you:

1. do NOT place lookups in the tables (see here for more about that:
http://www.mvps.org/access/lookupfields.htm

2. If you have a frontend/backend database, the relationships should be set
in the BACKEND, not the frontend.

3. You should not work directly in the tables or queries, but you should use
forms for user input. On FORMS you CAN use lookups (combo boxes, list boxes,
etc.) to select values from other tables and bind their controlsource to the
field in the other table you want to populate the data into (from the Form's
Record Source).

--
Bob Larson
Access MVP
Access World Forums Administrator
Utter Access VIP

Tutorials at http://www.btabdevelopment.com

__________________________________

 

[Shiblie Bshara]

Hi,
Thanks for the reply,

as for my query, I tried to do the relations on MS office2003 & it worked
while on MS Office 2007 it did n't.
Is there any settings problem?


Regards,
Shiblie.B
____________________________________________________________________________________________