N
niuginikiwi
Hi helpers,
I have this sitation where I need some or rather alot of help.
Scenario:
I have planting records (made up from different tables ie tblCrops,
tblPlanting, tblPlantingDetails, tblPaddock)
On these plantings I have I want to apply Spray Records ( come from
tblSpraying, tblSprayingDetails, tblProducts)
Since one spray operation can cover several planting records, I want to come
up with an easy way of having that particular spray operation 'hooked up'
with the planting records that I select , say on a list box.
Relationship btween planting and spraying is via a one to many relationship
including tblPlantingDetails and tblSpraying.
Im so much inclined to think that MS Access mdb is a Relational DB and every
record needs to be dealt with individually but there could be a way to do
this and I am asking you guys for your thoughts on this... just to make it
easy for my client.
Thanks.
I have this sitation where I need some or rather alot of help.
Scenario:
I have planting records (made up from different tables ie tblCrops,
tblPlanting, tblPlantingDetails, tblPaddock)
On these plantings I have I want to apply Spray Records ( come from
tblSpraying, tblSprayingDetails, tblProducts)
Since one spray operation can cover several planting records, I want to come
up with an easy way of having that particular spray operation 'hooked up'
with the planting records that I select , say on a list box.
Relationship btween planting and spraying is via a one to many relationship
including tblPlantingDetails and tblSpraying.
Im so much inclined to think that MS Access mdb is a Relational DB and every
record needs to be dealt with individually but there could be a way to do
this and I am asking you guys for your thoughts on this... just to make it
easy for my client.
Thanks.