help plz

[orbit]

ok hey i dont no anything about relationshops cud sum1 plz make my database so it gets the pricees from price.fp5 and puts them into paul.fp5 into the quote layout thanks

Archive.zip

[kenneth2k1]

I'll do it, just because I'm a nice guy

I would suggest in the future that you read the FileMaker instruction manual. That way you will have a better grasp of the concepts of FM and databases. Your file shows me that you have figured out some basic things and that is good. You just need a little more experience. Learn through experience.

I modified your files to show a SIMPLE relationship. However, you look like you are trying to make an invoice system. You will need one more file, which is called a "join" file. This file will store records that will be the line items of you invoice in the Paul file. This join file will have many records that look the same, but each record is for the many products that might be on the many invoices. This way the products (which right now is your Prices file) will maintain their integrity. You are going to want a clients file that will be separate from your invoice file (which is your paul file right now). I know this is a lot to digest at one time. Look up join file in the filemaker help is the best advice I can give. And try it!

To see how this relationship works, see the RELATIONSHIP layouts I created in your files.

have fun!

Ken

Archive.zip

[orbit]

hey thanks but how do i make it so it puts the price into the price field in the quote layout?

[kenneth2k1]

Read my post. This solution isn't what you are looking for. It's just showing you how to set up a relationship.

Hint: how do you add any field to a layout?

[AudioFreak]

Hint #2: Lookups are cool things

[kenneth2k1]

Yeah, lookups are good to know. They will pull data from other files, but it is best to understand how to set up multiple relationships for a true invoicing system.