Photo Catalog Relationship???

[Rochelle_505]

Greetings all,

Has anyone been able to link a photo from the FM7 photo catalog template to another table via a relationship?? I am trying to find out if there is a way to link my photos in the catalog to their invoice and have it all print.....

I was able to create a relationship between the two via invoice ID, but don't know what to do next???

[quillpro]

If you want the photo to show up on the invoice or some bit of information that is stored with the photo. Place the fields from the photos table into the invoice layout. Or vise versa.

[Rochelle_505]

I am willing to try this, but I am not sure where to put the fields on my layout. I tried putting a field in the body area, but then it was showing up after every record. The last part on my layout is a footer, any suggestions??

[quillpro]

There are a few ways. It depends on what you need it to do. Does each invoice only contain one photo? Perferably if each invoice could have multiple photos then you would what to create a new table called line item. Then each record in line items would contain the invoice # and the photo ID. The photo would display in line item and lines would display in the invoice. I can make you a sample or post your file and I can look at it to see what you need.

[Rochelle_505]

Thanks so much for your suggestions!!

The invoices will have one picture per invoice, except for just a few that will have about 2 or 3. I do have separate tables setup such as a Invoice table, line items table, customer, supplier, inventory, photo catalog, etc. The pictures will all be .jpg's, my question is how to link the pictures to the correct invoices? Where do I put the field on my layout, so it doesn't interfere with my report? I attached my line item's table for your review. Thanx again!

LineItemClone.zip

[quillpro]

Each record in line item should contain at least two bits of information. The invoice number and the picture. Then on your invoice layout you create a portal to display line items through the relationship base on Invoice ID from your invoice tqable and the Invoice ID from your line items table.

Where do I put the field on my layout, so it doesn't interfere with my report?

When you design your report don't include that field.

Your attachment needs the other tables to to functions.

I am sorry if this is not helping. I guess I don't understand your scenario clearly enough. If someone else has any suggestions please chime in.

[dkemme]

Quillpro is correct, you need to define a few things. Let's create a table called Stock with a number field called StockID, autoenter, serial number. Also put a container field Picture, text field StockName. Now another called Invoice, also with number field called InvoiceID, autoenter, serial number. As each invoice will order many items, lets create another table, Items, again with ItemsID serialized. Also create number fields InvoiceID, to link to the invoice you created, StockID, which will identify which stock item you just added to the invoice.

Now create a relationship, Invoice to Items by InvoiceID, allow creation of Items in this relationship. Next relationsship is a bit more tricky: Items to Stock by StockID but must be coming from the above relationship. This will make the data from Stock appear in the relationship. Just follow me for now.

Now create a layout, based upon Invoice table. Create a portal with the Invoice to Items relationship, put the StockID field from Items in that portal from the first relationship, which is Items table and StockName/Picture from the second relationship, which is the Stock table. When in browse mode the user will enter a stockID number and an Item record will be created and pull the name/picture from the stock table.

Attached is a simple example to help you with the database structure. It does not have any pictures but will give you and idea of were to start with your project.

Once you have the database structure, you can import all those pictures in the Photo example into this new database and you are off and running.

HTH

[Rochelle_505]

Thanks for your advice, I will try it out and let you know how it goes, thank you all again...