Split Database - Table Field To Lookup Values From A Query

[DaveCollins181]

I have a split database and need a field (Combo type) in the table to lookup values from a query in the front end. How do I do this as it doesn't see the querys because the front and back end are split? Thanks, Dave

 

[spikepl]

need a field (Combo type) in the table to lookup values

No you don't. Lookup fields do not belong in tables (despite the fact that Beelzebub made it possible). http://access.mvps.org/access/lookupfields.htm

In a form you can use the lookup table in a combo. Or else, make a query so that the query also displays the values.

 

[RainLover]

The fact that this is split does not matter at all.

You have everything on the front end. The only difference is that the tables are linked to the back end. They behave in the same way as if the database was not split.

 

[DaveCollins181]

Hi Spikepl, well you learn something new everyday. I was unaware that Lookup fields in tables were not the done thing or that they were the work of the dood downstairs I have now inserted a combo box into the form which looks up the value from my query and stores the chosen value in the field I need it to. Hey presto it works. Thanks for the prompt resolution to my problem. Dave