Newbies justOneMoreThing Posted December 6, 2004 Newbies Posted December 6, 2004 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...
transpower Posted December 6, 2004 Posted December 6, 2004 Just put the Description field on the layout of the ordering table.
Newbies justOneMoreThing Posted December 9, 2004 Author Newbies Posted December 9, 2004 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
Newbies justOneMoreThing Posted December 9, 2004 Author Newbies Posted December 9, 2004 Not to worry i have managed to get it working now
Recommended Posts
This topic is 7290 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now