Hi Guys,

Sorry to bother you with this question. Actually I'm still confused what is the best link to set to my Drop Down Tables.

Example:
tblClient (MASTER)
ClientID
FullName			tblDesignation (DROP DOWN TABLE)
DesignationID---------->DesignationID
				DesignationDesc

My objective is, once the DesignationDesc updated, automatically it will reflect to the master DesignationID. But one thing I
noticed is, even without linking the ID, the above is achievable by setting up the DesignationID Lookup to the tblDesignation. (true
or false?)

One thing, is it advisable not to allow the user to delete any record on the drop down table if it used?

Can anyone give me the best approach to achieve the above without forcing the user to input the value on the drop down field?

Any idea and tips is highly appreciated.

Cheers,
George

How does this sound:

Set basic Referential Integrity on the relationship between tblClient and tblDesignation (Don't 
worry about Cascading deletes and updates). 

The way I see it - that will solve the problem there and then.

Steven

Thanks man, it's working.

Appreciated,
George


-----Original Message-----
From: Steven White [mailto:Steve.White@m...]
Sent: Wednesday, August 21, 2002 12:26 PM
To: Access
Subject: [access] Re: Still Confused!


How does this sound:

Set basic Referential Integrity on the relationship between tblClient and tblDesignation (Don't 
worry about Cascading deletes and updates). 

The way I see it - that will solve the problem there and then.

Steven