Union Query ?

[fibayne]

Hi, not sure the best to achieve this but think perhaps a Union query ??

I have an application table which holds the client name, intermediary name, adviser name and life insured name, the primary key on this table is ClientAppID
Client Name and Insured Name are stored in tblClientMain and Intermediary and Adviser are stored in tblInterAdv
I would like to be able to combine client,life assured, intermediary and adviser into one list to be used as the record source for a combo on a payee form the list needs to be able to accept new entries (not one of client,life assured, intermediary as a payment may need to be made to an unassociated person at some point...) which would be stored in tblPayee

I have searched and found union and select distinct but am unsure which and how to use them in this scenario if at all .....as always any help or guidance is much appreciated.................cheers Fi

 

[neileg]

A union query will allow you to combine your existing data but I'm pretty sure it's non-updateable so you won't be able to add new records. Do do what you want will probably require you to have just one table for all the names with a field to indicate what type of contact they are. Could be a lot of work.

 

[fibayne]

Hi Neil...having read a few other posts I was beginning to think that this woud be what I would have to do, fortunately the DB isn't live yet so tis sort of change can still be done...I will continue to search for a way to do it though perhaps using VBA ??
thanks for replying ....cheers Fi