Hello:
I have three tables in my database called:
- Groups
- Events
- Groups_Events
I want users to go to the Groups table in ASP Runner application, then see a detail recordset of "Group Events" which would be a query linking both the Group_Events and Events table. I can do all this. The problem comes when I want users to be able to add an event to their group. Because the primary key from the events table needs to be entered as a foreign key in the group_events table, this seems difficult to do in ASP Runner. Is there a way to add a record to a query that inserts the primary key from one table when a record is created into the foreign key field in another. The group foreign key would be inserted by virtue of it being a master-detail relationship in ASP Runner.
I hope this makes since. Can anyone help me. Feel free to ask for clarification.
Thanks!
