G
Guest
I have just switch over to ADP with a SQL backend. I have two tables
AirspaceMissions and Bombdrops. Every mission might or might not have dropped
bombs. I want to display all the Missions that flew and have the BombDrop
fields be displayed so the user that is updateing the Bombdrop info can go in
and edit the fields on a continuous form. In order to see all the missions
regardless of wheter there has been any bomb data entered I have to create an
outer join with the BombDrops table in the query. This worked fine in Acces
but now I can't update the bombdata with SQL. Should I be using a stored
procedure instead of a View. I'll post the pertenant fields of both tables.
There will be only one record in the BombDrop table for every record in the
AirspaceTable, if any bombs were dropped. I hope I have explained this
clearly enough Thanks for your help.
AirspaceMissions
Airspace Id (PK)
TimeOnRange
TimeOffRange
BombData
BombDataID(PK)
AirspaceId (FK)
BombType
Quantity
AirspaceMissions and Bombdrops. Every mission might or might not have dropped
bombs. I want to display all the Missions that flew and have the BombDrop
fields be displayed so the user that is updateing the Bombdrop info can go in
and edit the fields on a continuous form. In order to see all the missions
regardless of wheter there has been any bomb data entered I have to create an
outer join with the BombDrops table in the query. This worked fine in Acces
but now I can't update the bombdata with SQL. Should I be using a stored
procedure instead of a View. I'll post the pertenant fields of both tables.
There will be only one record in the BombDrop table for every record in the
AirspaceTable, if any bombs were dropped. I hope I have explained this
clearly enough Thanks for your help.
AirspaceMissions
Airspace Id (PK)
TimeOnRange
TimeOffRange
BombData
BombDataID(PK)
AirspaceId (FK)
BombType
Quantity