hi

have a db i am desiging to track operations performed on patients, the patient side of db and procedures are joined togther

i am having trouble creating records in the join table using value lists from the operation db

have a look at the attached db schema - any tips please?

cheers

rick

Welcome Rick!

>>i am having trouble creating records in the join table using value lists from the operation db

Which table you are trying to add records to, and how are you trying to add them? Through a portal? If so, from which table? What kind of "trouble"?

ender

thx for your reply, subscribed to filemakermagazine over the weekend and downloaded some of matt petrowsky's videos which explained what i needed to know

what i have down is use scripting to take values from one form to another, create a record and return to the main form with the new record showing in the distant portal

thx again for reply

cheers