mrhooper Posted September 17, 2007 Share Posted September 17, 2007 Hello, I am trying to re do our company job database and am stuck on something I think should be simple. I have a job order table that relates to our customer table. With a new order being input, I would like the person who enters the order to be able to start typing the customer name, and it would fill in by looking to the customer table. Well it is not working, I have a parent and child key to set the relationship. Tried setting the field as a dropdown list, which works but then non of the other fields are populating with the related data. Probably something simple i am missing. Am a bit rusty, havent used FM since v5. Link to comment Share on other sites More sharing options...
SoCalMacDude Posted September 17, 2007 Share Posted September 17, 2007 When you define the fields that need to be filled in, set an Auto-Enter by Lookup, through a relationship with your customer table. Link to comment Share on other sites More sharing options...
mrhooper Posted September 17, 2007 Author Share Posted September 17, 2007 I tried that with no luck... I think maybe my relationship is not set up right? As an example: I have a key value which is say customerID in the customer table. and a customerIDfk in the new job table. These are related. In the field of the Job Table, I type in the name of the customer and it should narrow down a list from the customer table. The other fields I have set up phone, address, etc. should show up when tabbing to the next field. That is how I understood it to work. So far, I get zilch. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6158 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