Hi

Each item in my database has 2 play names with 1-10 points each.

However, I can't get the second name to have its own point system. I am not sure how to set the relationships so each play name works separately.

here's three separate database files and another file that does sort of the same thing in one file.

I don't really get relationships very well.

Anyways, if someone could point me in the right direction for the second play name, that would be great.

You can log in as guest.

TEST_dbases.zip

Edited February 10, 200619 yr by Guest

can you explain better what you want to accomplish? what means play? player or like rolling a dice play? in case i do have understood you right, you could do the following relationship wise:

item_db(id {auto_entered_serial}) --> play1_db(id)

item_db(id {auto_entered_serial}) --> play2_db(id)

now you could make a portal on a layout residing in the item_db to show records created for those items. and sum the points given for both using a calculation field.

Edited February 11, 200619 yr by Guest