large amount of fields in a table is it a good practice?
I am planning a new system and I want to store lots of different data from the same forms but rather than getting too complicated linking loads of tables I am thinking about one main table with loads of fields in.
then in the form all the fields will be present but depending on the selected data in the first couple of fields to what is actually displayed on the form.
I was then thinking about using conditional formatting to hide or show the relevant fields based on the data selected in the first couple of fields.
I am not sure how big this will be yet but I think it could have a lot of fields to work well.
Is this a good practise?
will it run slow due to loads of fields?
will it still run ok and fast via my Ipad APP?
I would appreciate your comments.