posted 15 years ago
Hello,
I'm working on a DB with the following structure:
[Events]
eventid:int - auto generated, primary Key
name:varchar(200)
type:int
[Problems]
problemid:int - auto generated, primary key
name:varchar(200)
type:int
[EventsProblems]
linkId:int - auto generated, primary key
eventId: int - FK referencing events table
problemId: int - FK referencing problems table
So I need to add a problem to an event, this implies to insert in the link table the id's
of the other two tables. Can you recommand me a decent way to do this?
ZT