Re: FileMaker--how to match and flag IDs in two tables
Re: FileMaker--how to match and flag IDs in two tables
- Subject: Re: FileMaker--how to match and flag IDs in two tables
- From: Bruce Robertson <email@hidden>
- Date: Tue, 20 Mar 2007 12:29:16 -0700
> Hello,
>
> Tiger.8
> Filemaker Pro 8.5 Advanced
>
> I have two related tables in an FMP file.
>
> Table A has ~300 records, B ~2,000.
>
> Each record within A is unique for sure; I am almost certain that each one
> within B is unique.
>
> The goal is to determine whether any of the records in A match one in B based
> upon student ID.
>
> These IDs are like social security numbers; i.e., they are preassigned, unique
> 9-character values rather than ones that I'm assigning within FMP.
>
> Like SSNs, these IDs are unique. So within Table A, each ID is unique.
> Likewise, within B the IDs are unique.
>
> However, some IDs in A might also be in B. I need to find out programmatically
> which ones, if any, are in both tables.
>
> If a match exists, I need to flag a field in each table.
This can be done with no scripting of any kind.
Set up a relation between the two tables based on the ID field.
Place a copy of the related ID field on a layout (preferably formatted to
allow entry only in Find mode)
Enter find mode.
Enter * in the related ID field.
Perform your find.
Done.
Alternatively, it can be done with a one line Filemaker script.
If called from File A:
Perform Find [ TableB::Idfield; "*"]
_______________________________________________
Do not post admin requests to the list. They will be ignored.
AppleScript-Users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
Archives: http://lists.apple.com/archives/applescript-users
This email sent to email@hidden