how do I manage this?

[feeder23]

Hi,

I will give an example of my problem

Well, you have 2 tables, table1 and table2

in table1:
first field: autonumbering
second field: number (e.g. 1, 1, 2, 2, 2, 3, 4, 5, 5, 6, 7, 8, 8, 9, ...)
third field: text (in all records different)

in table2:
first field: autonumbering
second field: text (e.g. a, b, c, d, e, f, g,...)

Now, in my relationship is the 2nd field of the table1 linked with 1st field in the table2

so for second field in table1, i could use als a, a, b, b, b, c, d, e, e, f, g, h, h, i, ...)
i did this for easily adding records in table1, only add autonumbering of 1st field table2

now, when I make a little form with a combo box with the records, a, b, c, d, e, f, g, ... and then push OK-button, now you can add a new record for table1, then this should happen


a form of table1 will be made:
first field: autonumbering+1
second field: if I chose "a" in the combo box, 1 must appear in the 2nd text box. for b, 2; for c, 3...
third field: empty

Has someone a code for this problem?

greetz

[Ecniv]

What code do you have?
Shouldn't your combo box have a hidden ID column you can use ... whilst displaying the second column?

[feeder23]

ooh yes, indeed.

and how is it possible to copy/paste this number that stands in the combo box with a code?
remembering and then typing the number, was unacceptable for my copromotor.

greetz