Hi5 wrote:
Hi,
Many thanks for your answer, Of course the datasets are different.
we have the Primary and foriegn keys that are numbers and are the same
in all realated tables,to make it simple I.E.
I need to input client from a dropdown and category from a text box in
one go is there any way of doing that?
many thanks
Are you talking here about inputting the client that is chosen from the
drop down - "combo box" in Access - and whatever is in the text box into
a table, as a a single record?
Or, does the client from the combo box tell you what table the text box
needs to made a record of?
Or, will the client choice in the combo box specify what records from
another table need to be inserted into a specific table?
The way to do this is in code, associated with a command button, that
writes the SQL statement you need and the executes it. You can figure
out how to write the SQL statement by setting one up on the Access query
design window and then switching to SQL View (Click View->SQL View).
Copy the SQL and break it up to put in values from the text box and the
combo box in the appropriate places.
If you're not sure how to write the code, respond back with an answer on
the questions I make above and I'll try to show you how to do this -
enough at least, to set you on your way! 8)
--
Tim
http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me