Alright here's another one:

Our databse has many tables, most of which relate to a single property record.

I want to be able to perform a photo import, where we'll import 20 photos or so for one property. I have a photos table, related to the property table, but the trouble is telling FMP what property to relate the imported photos to.

If the property number was in the photos file name, no problem. (Say file name was 300a, 300b, 300c, etc., all these are for property "300"...I could just get the filename as a number, and import this into the field related to the property ID).

However, I want this to be simple. No file naming or anything manual.

You're in a layout for the subject property, and you hit the "photo import" button. It imports ALL photos on the connected memory card into the photos table, but relates them all to THAT property.

I can't figure out how to do this...

Idears?

When you begin your photo import scripts I imagine you'll want to send the ID number of the current property to a global field. Then, after you've imported your photos, perform a replace in the newly created found set of photos, setting them all with this property ID which you've temporarily stored in your global field.

HTH.

Thanks for turning the light on for me!

"DUH"!