I'm having trouble setting up what I think should be a very simple form.
I have a table which has (amongst other things) a field called "Reference" and a field called "Item".
An Item can have a Reference and a Reference can have several Items i.e. :
I want to have a form which is in two halves.
In the top half, I want to enter the Reference and have it list all the Items.
In the bottom half, I want to enter the Item and have it display the Reference.
All help and pointers greatly appreciated.