Filtering a value list based on entries in a portal

[Res]

Hi all,

I apologize of this is in the wrong forum (I could not tell whether it belonged in portals or value-lists).

I have a simple database with three tables:

ActorsTable (ActorID, ActorName)

JoinTable (ActorID, SkitID)

SkitTable (SkitID, SkitName) with a Portal (JoinTable::ActorID)(ActorsTable::ActorName)

I am using a value-list based on the fields ActorID and ActorName (from the ActorsTable), to add the actors to the portal on the skit table.

The problem I have is that I can add an actor multiple times in the portal.

Is there some way to filter a value-list to exclude actors that have already been added to the portal (but will not remove them from the value-list for other records)?

Thanks in advance

[Genx]

Make another occurance of your actorstable, set the relationship between actorID in the new actors table occurance and ActorID in the join table as not equal to. Then pull the value list from your second actors table. Im just head theorizing here.

Also, Im not sure the value list will refresh until you've commited your changes to the file, i.e. clicked out of the portal. One work around for this is to not allow creation through your portal and script record creation in the related table instead.

~Genx

[Res]

-snip-

Also, Im not sure the value list will refresh until you've commited your changes to the file, i.e. clicked out of the portal. One work around for this is to not allow creation through your portal and script record creation in the related table instead.

~Genx

It sounds like this might be the way to go, but I have never done much with scripting, so I'm not sure how to begin.

[Genx]

One way would just be store skitid in a variable, go to a layout tied to your join table TO, create a new record and set the skitid = the variable i.e:

Allow User Abort [Off]

Freeze window

SetVar[$SkidID ; SkitTable::SkitID]

Go to Layout [Any Layout tied to JoinTable]

New Record/Request

SetField[JoinTable::SkitID ; $SkidID]

Commit Record

Go to Layout [original layout]

Option 2: Make a new timestamp field in your join table, and a new calc field with result timestamp in your skit table (with equation Get(currenthosttimestamp) ). Next, create another join TO and join it to skit by relating skitid to skitid and the calc field to the time stamp field. Double click on the relationship between your new join table and your skit table, and allow creation of records on the join table side. Finally, you just use a mini script to generate the record:

Setfield[JoinTable2::SkitID ; SkitTable::SkitID]

Commit Record

Refresh Window

~Genx