Thank you Phil.. but the problem is am new to filemaker make. Here am attaching the invoice file.. So i need the Product ID and Product name lookup each other...so either i can select from id or from product name....
Geez anoobs, that was 2 years ago. Have you been working with FM for 2 years, or did you put it down and just pick it back up again. In the meantime, if I can get your file to open I'll take a look.
Here's a modified simple version. Unfortunately it's in FM12.
On the Products Table
Made 2 global fields. One tied to a dropdown of Product Names-object named "Name", one tied to a dropdown of Product ID-object named "ID" (don't know why you would search by ID)
Attached an OnObjectModify script trigger to each dropdown field w/ above mentioned script parameters:
Enter Find Mode [ ]
Set Field [Products::Product Name; Products::gSearchName]
Else If [Get(ScriptParameter)="ID"]
Set Field [Products::Product Name; Products::gSearchID]
Perform Find [ ]
Set Field [Products::gSearchName; ""]
Set Field [Products::gSearchID; ""]
InvoicesMod1SM.fmp12.zip 350.5 K
I didn't checked it but and its been a long time here. when in logged in found some reply's and i replied to them. I put another doubt here. it would be so grateful If you are able to give me a solution for that.
Thank you steve for your valuable suggestion. Am not so expert in filemaker. Please help me with my doubts.
Does the sample file help? On the right track?
yes... and this is other doubt..
I have to Tables, Parent Table & Child Table. Actually this is video gallery. I want to show some field from child table in Parent which is a interactive container. I tried a portal from child table in the parent but it didnt show any video. but without portal i can video one video. I have many videos in child table for a single record in parent table. I use interactive container because it will insert the video as a storage folder but quick time save only as a link. So if i have button to upload video it will copy that current video to storage folder. If i insert the video as quick time i cannot open the same file from other computer coz it show missing video links. My Qn is
1) Is there any option i can show multiple videos from child table in Parent table without portal?
2) or can i insert quick time in child table container field and view in parent table as portal but can i use the same file in multiple computer without losing its link?
please help.. Urgent!!!