Hi guys,
I have hit a wall here. I have devided 1 table into 2 since the amount of fields exceeds the maximum allowed for 1 table. Furthermore, I use a separate form for each table. The key field in both tables is "Item number".
Here is what I want to do: When I write an item number in the "Item number" field in one of the two forms, I want this item number (the same record) to be shown in the other form, when I open it. This way I can continue writing to the same record without having to write the same item number in the second form. I hope you know what I mean.
Is there an easy way to do this?
Thank you very much in advance