simple auto fill from one db to another

[rcrowell]

I am sorry if this has been covered, but I couldn't find exactly what I needed.

I have two dbs one is networks(client addresses) and the other is an order form. I would like it when you type in the name of the network their other information would then poulate the other remaining fields. Such as I have described below.

Network: TWC

Phone: XXX-XXX-XXXX

Address: XXX

Fax: XXX

Contact: XXX

I have set up a relationship from the network db to the order db and tried to type in the information and see if it would match up, it doesn't do anything, I realize I am doing something wrong, but I am at a dead end, I have set the match field to be network being that is the common denominator. Please help.

I have attached the file if anyone would like to look at it.

Thanks, Ryan

[LiveOak]

The problem is that you have not defined any fields in Insertion_Order to lookup data from the Networks file. This does not happen automatically by creating a relationship. You must go to the Options dialog in "Define Field" and set each Insertion_Order field to lookup using a specified relationship and from a specified field in Networks. This is how FM knows which fields to lookup from which fields using which relationship.

-bd

[rcrowell]

I'm sorry I am confused on this, but I am missing something. The fields in the I_O db are assigned as relationships (ie. ::Network) where do I go into define fields in I_O or Networks db. Currently I have assigned a lookup as such Network to Network, Senior Planner to Senior Planner, and so on...that didn't work so I tried to take the relationships out and do straight lookups and that didn't work, I am still missing something on what must be a very simple problem.

Ryan

[LiveOak]

I think you may be using the term "lookup" incorrectly. The field you have displayed from the Network file in the I_O file are "Related" fields, not lookups. The Lookup process actually moves values from a file to native fields in another file based upon a relationship.

The reason that your display of related fields from Network isn't working is that you don't have any values in the Network field in the Insertion_Order file. The Newtork field on your layout in I_O is the related field from the Network file. It and the other related fields are blank as no relationship is established until the Network field native to the I_O file is filled out.

In Layout mode, change the field ::Network on the I/O layout of the I_O file to the Network field native to the I_O file and then enter a value.

-bd

[rcrowell]

Thank you very much, that was an "ah ha!" moment for me. It works perfectly now.

Thanks again.

Ryan