I'm trying to do the following:

I have 2 Forms:

1) MEMBERSHIP INFO

2) TABLE_MEMBERSHIP

I have created two fields in "MEMBERSHIP INFO" form: "Membership Level" and "Membership Price"

The "Membership Level" field is a drop-down list that is Looking Up pre-established Member Level information within the TABLE_MEMBERSHIP form (specifically "Member Level" and a corresponding "Member Price").

I would like, when the user selects from the drop-down list in the MEMBERSHIP INFO form for it's pre-determined price (located in the TABLE_MEMBERSHIP form) to appear in a second field called "Membership Price" that's also in the MEMBERSHIP INFO table.

Does that make sense?

I'm pretty sure it's a "Fetch" operation in Deluge but, for the life of me, I can't get the syntax right. I looked and looked and looked at the Library Book tutorial and never got it to work for my project.

Thanks so much for any info anyone might have.

If you need me to clarify, I'd be happy to.

Thanks!

Sean