normalised table - great! entering viewing data - HELP

[oli82]

Hi,

Thanks for help in advance. We have a table with data stored like in the top table. This is normalised and great but while it is easy to create a form when the data is stored like in the bottom table, I am at a loss with how to show forms with this data. Ideally I would like for each car to have every available property available on the form and then when the record is saved any fields which are null are ignored and all the others are added to the table. I am looking into using ADO but it looks tricky - especially trying to view the data once entered, I think I can make something for entering data. Any advice would be unbeliveably helpful.

Thanks,

Oliver

 

[gemma-the-husky]

the trouble is the lower grid is unnormalised

easiest way is to have a separate query for each attribute (ie seat, wheel etc)

then have a master query based on car, with a left join to each of the subqueries.

now EVERY CAR is included, together with the respective attributes.

 

[oli82]

Dave,

Thanks for the help. we dont have any data stored like the bottom table it was in their to say that a form based on that would be easy. But I have the issue of turning data stored in the top table into a form that displays every possible option of property on the form.

Thanks for the help.

Oliver

 

[gemma-the-husky]

yes i know

i explained the steps you need ot take to generate reusults like the lower panel

 

[oli82]

Dave,

Will I be able to add new records/delete/edit properties through these queries?

Many Thanks,

Oliver

 

[gemma-the-husky]

i suspect not

try it and see - there is bound to be a workround anyway - just depends what you want to achieve