Hi to anyone that can help,
I am rather novice in access. What I need to do a lookup probably a
Dlookup I guess?
I have a form that is looking a base data. The data comes up on the
left hand side of the screen. Based on what comes up in the basedata,
I want functionality and flexibity that allows a series of dropdown
box or a text box to look up different tables and give me a results
and place them beside the basedata boxes. So therefore I have basedata
table, but many tables bringing in info to the front form. Once I get
all info into my form I want a macro to pick this data up and place
every bit of data inclusive of basedate into another mothertable.
I am a little worried because I think Dlook's are slow aren't they? As
I haven't done a lookup before, could someone show me how to do that
first, e.g( based on the result, say base data is 1.50 can I look at a
table and say if between 1.4 & 1.6 (which 1.5 clearly is) look up a
table and give me information. Basically this is very much like if
statements in excel but looking at tables.
Once I sort this out then I will look at moving data into a mother
table.
I hope this makes sense.
Thanks
TW.