Finally learning this.. slowly

[pullmyefinger]

THANKS AGAIN to all those who have helped me on this #@R database!!

I know this can be done, but I want to do it the right way


My Form has a combo box with these fields:

ID 1-4, unique

location: north, south, etc. (text)

seqnum: Numeric/Integer

loccode: (location code) N, S, E, W (text, 2)

The info above is stored in the "locations" table and has 1 record only.

----------------------------------------------------------------

There are textboxes tied to the table EQPT (equipment) with field names

Seqno (text, 2)

loc (text, 2)

Itemcode (supposed to be a concatenation of seqno+loc; (text, 4))

----------------------------------------------------------------

What I want to do is to:

1. pick a location in the combo box

2. have the sequence number updated (this/the cbo works via a query)

3. concatenate/splice the values in (1.) and (2.) to another field in the EQPT table called ItemCode.

4. "link" or "bind" or "tie" the fields in the "locations" table (the combo box) TO the corresponding fields in the "EQPT" table as:

a. loccode (locations table, cbo box) gets written/tied to loc field in EQPT table (textbox)

b. seqnum (locations table, cbo box) gets written/tied to seqno field in EQPT table (textbox).

c. itemcode (EQPT table (textbox)) gets written/calculated/expression as loc+seqno in the EQPT table.

d. This should happen automatically so the person doing the data entry
Cannot mess with these fields. The result of the calc'd / expression field Itemcode in the EQPT table should be displayed only.

Do I do a lookup/dlookup/query And Which Event(s) do these get put in??

Thank you so much..