I have just got the program and am trying to set up something very quickly (and basic).

I have 2 databases - 1. a forms database (a list of company forms)

2. an ordering database (to order one of the forms)

The 2 databases have 2 related fields which are "Form Ref Number" & "Description".

I have populated the forms database with around 7 entries and what i want the ordering database to do is when the user is creating a new order, when they click on the "Form Ref Number" a popup of the form numbers to appear so one can be selected (i have this working and its gets the data from the forms database no problem).

However i want it to also bring in the corresponding "Description" automatically when one of the "Form Ref Number"'s are selected from the popup list.

Can anyone give me any advice on this, cheers...

Just put the Description field on the layout of the ordering table.

yeah i have tried that but it still doesn't work. In the relationships setup i have linked the 2 associated fields yet the description field still remains blank when a form number is selected from the popup menu

Not to worry i have managed to get it working now