question and help needed

[burak]

Hi everyone,

I've designed a form in access 2013. My problem could be explained briefly as;

I want to an automatic numeric code (-which listed in a table connected to main form and main table-) indication in one box of the form; when I will enter the data such as name or department in another field (-which also listed in another table connected to main form and main table-) of the form. For instance;

I enter "the name", than automatically "the code" screening in other box of the form.

Thanks a lot to everyone for helpfull contirbutions,



Burak

[burrina]

So, basically you want a counter. You can do this many ways. You could generate a Unique code based on another value.I don't have enough details to suggest anything else.
Example:

Me.MyTextbox = Nz(DMax("SomeField", "SomeTable") & Format([SomeField], "0000") + 1)
UniqueNumber = Nz(DMax("SomeField", "SomeTable") + 1) 'Increment Number By One.

HTH

[June7]

Do you want to create a unique ID or do you want to select data and save existing ID?

Maybe you need a multi-column combobox http://www.datapigtechnologies.com/f...combobox3.html.

[burak]

Thanks a lot for your helpfull contribution. The beta file attached. I basicly need that; if I select in main form i.e. "PR unit" in Sender field and "Exhibition" in main subject field; than automatically "GMD.PG-0100-14" (from sender code table) indication in sender code field and "1940" (from main subject table) in main subject field in main form by saving to main table simultaneously.

Best regards & thanks again so much ...

[burrina]

Their is NO GMD.PG-0100-14 in Table SenderCode ? You have 4 values to choose form, what is your criteria for determining which one?

[burak]

Thanks again Burrina for your help & attention,

I send to you an excel attachment in order to explain; which "user input data" equals which "automatic display data". The user enter the data in main form "sender" & "main subject" fields than the codes going to indicate in "sender code" & "main code" fields automatically and totally will save to main table simultaneously.

Regards,

[June7]

If MainSubject and MainSubjectCode are synonymous values, then make one table with both fields.

Same for Sender and SenderCode.

Then in main table save only SenderCode and MainSubjectCode values, not the descriptive text. Retrieve the descriptive text in queries that join tables.

You need a better understanding of relational database principles and the use of primary and foreign key fields.

You are using multi-value fields - I NEVER use multi-value fields.

Advise no spaces or special characters/punctuation (underscore is exception) in naming convention.