Relationship Affected Value Lists

[robo_obi]

I'm not sure if this is where this belongs but hopefully it is. And hopefully I'll make sense.

-----------------

I'm creating a card game and I need a way to simulate multiple piles of cards. I've not had alot of experience using tables with value lists in FMP7 so any help would be greatly appreciated.

My concept is this:

Table: (cards)

Fields:

Card_ID - holds the id for the card (1 through 4 for suits, 1 through 13 for value, separated by a - )

Card_Pic - container holding the cards picture

dealt - this and the fields below would hold either a 1 or a 0

played - see above

pickup - see above

discarded - see above

Table: main

Fields (for now):

dealt_list

played_list

pickup_list

discarded_list

These fields would hold the Card_ID's from Cards that have a "1" in the respective field. ie all cards with a "1" in the "discarded" field in Cards would be placed in this list.

When the cards are dealt (there are 18 in total at start of play, 9 per player) those cards are entered into the dealt_list in the same order as they were placed.

The remaining cards are then placed randomly in the pickup_list value list and so on.

-----

The main problems I need a solution to are using the 1's and 0's to designate which list a value is put into and then getting the lists changed and kept in order of play via scripts

----

i realise i explained that badly...but hopefully someone can help me