Hi! I have a problem. as a Customer and equipment, I have two layout. I will give auto serial number for customer id. I want to give also auto serial number for equipment as a related by Customer.

For example My Customer name "John" and id number 1.

If John takes five equipment, five equipment id number get 1, 2, 3, 4 and 5. after that Customer name "George" and id number 2, George takes four equipment. four equipment id number get 6, 7, 8 and 9. It will go on like this. How can I make me by using file maker? Thanks all friends.

What if George takes an equipment, the same equipment taken by John ?

Yes, but I have to give a special serial number for all equipments for each customer. So that equipments is the same. For example ; George has takes a broom, bucket and brush. Michael has takes the same a broom, bucket and brush. File is the same equipment and this database also has a repeating files.I want to give repeating files database a different numbers as a referance by the other file. Thanks a lot.

You'll need at least 4 tables:

Customers

Equipments

Orders

Order Line Items

The autoentered ID of the last table meets your needs.

Can you explain how to make, I tried but I couldn't make relationship, thanks alot

Give a look at this file from Comment.