Going about it all wrong??

[sandpilot]

Hello All,

I'm just getting back into FileMaker after several years of not using it. I have taken on a project for a friend to try to help out and can't for the life of me make it work the way I want. Here is the situation. I will have two separate databases, the first will contain individual products. Lets say it will have fields of part_id, part_name, part_size and part_price. There will be several hundred individual parts, each with a unique id. This part I have under control.

The second will be a quote and invoice database. In the body of it I will have an ID field the will have a relation to the ID field in the first db. It will populate the rest of the fields across, part_name, part_size and part_price. In the second db I set the fields to be "repeating fields" with 10 repetitions down. The first row works just fine when I enter the ID, it populates the rest of the fields across in the row.

The problems is when I jump down to the second row of the repeating field and enter a new part_id number, it does not populate the fields across with the information of the second part number. Instead of having just one id field with repeating fields, should I make id_num1, id_num2, id_num3 and so on, each linked back to the original db?

So my question is, is this the right way to get to where I'm trying to go? If not, can someone point me in the right direction, web site, book, video or whatever the best practice is for doing this trick.

Thanks much for the help.

John

[jteich]

You need a third table as join table between products and invoices called 'line_items'.

-jens

[John Mark Osborne]

Here's an example file from my web site demonstrating an invoicing solution. Hope it helps.

http://www.filemakerpros.com/joinprint.zip