Newbies Tanerongunyzb Posted June 10, 2010 Newbies Share Posted June 10, 2010 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. Link to comment Share on other sites More sharing options...
Raybaudi Posted June 10, 2010 Share Posted June 10, 2010 What if George takes an equipment, the same equipment taken by John ? Link to comment Share on other sites More sharing options...
Newbies Tanerongunyzb Posted June 11, 2010 Author Newbies Share Posted June 11, 2010 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. Link to comment Share on other sites More sharing options...
Raybaudi Posted June 11, 2010 Share Posted June 11, 2010 You'll need at least 4 tables: Customers Equipments Orders Order Line Items The autoentered ID of the last table meets your needs. Link to comment Share on other sites More sharing options...
Newbies Tanerongunyzb Posted June 25, 2010 Author Newbies Share Posted June 25, 2010 Can you explain how to make, I tried but I couldn't make relationship, thanks alot Link to comment Share on other sites More sharing options...
Raybaudi Posted June 25, 2010 Share Posted June 25, 2010 Give a look at this file from Comment. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 5067 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