Jump to content

Relation and lookup


mrhooper

This topic is 6120 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

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

This topic is 6120 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.