Add Data from 2 tables?

[Bryan VonDeylen]

I have a DB solution so workers can sign up for work, but select the Activity, Date & Time to sign up.

Tables [fields]

Activity [ActID]

Activity Date [ActID, ActDID]

Workers [WID]

Signup [WID, ActID, ActDID]

Each Activity can have many Dates/Times

I would like a worker (from the Worker table) to select an Activity and Activity Date from a portal to sign up.

Problem is, I can't figure out how to get the ActID and ActDID from the one portal to the signup portal to create a new record (last row).

AthleticDept.fp7.zip

[Oldsneekers]

The first that comes to mind when looking at your structure is that the worker (either by selecting his name from a worker list or by log in confirmation) identifies himself which puts ID data into a global field/s.

Then the worker selects the activity and date he wishes to work in using a button in the respective portal row. That button is scripted to enter the activity data into another global.

Assuming that Workers is your display layout, the button in the portal row could do both above actions if the display layout shows the workers ID. The portal row button would take the worker ID info from the Workers record and enter it into a global field, enter the activity portal row ID info into another global, the script will freeze the window, go to the layout Signup formated to Signup, create a new record using the information in the globals, then back to the original layout.

good luck.

[bruceR]

Like this?

athleticdept.zip

[Bryan VonDeylen]

Possibly.

All I need is for a way for people to sign themselves up for an Activity (Boys Basketball JV / V) and a Date/Time.

After that is done, we have an Activity coordinator which looks at all the signups and what the people elect to do (Supervisor, scorer, etc) and assigns them the job.

In your example which you attached, you had people sign up with the job as well, which we would not need.

But what you did, accomplished what I needed (thank you) and gave me more.

[Bryan VonDeylen]

Bruce,

I wanted to thank you for the modified file you attached. I learned something new. Conditional formatting! I was wondering how you got the selected portal row field to bold, and I figured it out so that the Time Field would also bold when the row was selected. Cool!

My next step is to put this on the web using php and allow workers to sign themselves up for Activities.

Couldn't have done it without your help.