Pick data from Another file that don't have relationship

[Arif Mustafa]

Dear All,

I'm FileMaker beginner and I'm trying to make an application for practice.

I create work order form that have portal in it, the portal will hold work order detil.

The work order fields will be ('Work Order Number', 'Customer', and 'Date'). The portal will hold ('Work Order Item', 'Description', 'Quantity', and 'Work Order Status'). This is what I actually want. When I create new work order record, I want 'Customer' field filled by pick up customer data from file "customer.fp7"

How to make this things possible in FileMaker Pro 7 ? Customer fields will be like this ('Customer ID', 'Customer Name', 'Address', 'Phone', 'Email', 'Website').

Please, I need to know how to do this? because I'm stuck on this.

Regards

Arif Mustafa

[CyborgSam]

Arif->

Welcome to the Forums!

You'll have to relate the two files so FileMaker will know how to access the data. In the work order file, define a File Reference (File>Define>File Reference) to customer.fp7. In File>Define>Database, relate the field "Customer" to the unique key CustomerID in customer.fp7. If there are not too many customers, you could use a popup menu or list to display them. If there are a lot, a portal may be the best way.

[Arif Mustafa]

Thank you for your response,

but I still not figure out what you're say.

What I need to get is like the attached image.

When I click the "pick" button on "work order" form I pop up a new window contain list of customer with "pick" button, what I want is: when I click this button, the "Customer" field in "work order" form filled by "customer ID".

help me : please.....