Forms Based on tables or Queries

[Tuckejam]

My db, which started as a learning project, has reached a size and age where I can no longer remember why I did some things the way I did them.




I have frm_HouseList which is based on, or directly dependent on tbl_Houses (and related tables like house type etc)


the I also have frm_transactionsList which is based on, or directly dependent on qry_transactions Which is based on, or directly related to tbl_Transactions (and related tables like transaction type etc


I am trying to figure out if there is a reason I set these up differently, Is having a form based directly on a table just bad design and this was a learning error? or would there be a reason to set something up this way?


Thanks for your thoughts

[Bob Fitz]

As good as some of our members are, I'm not sure that any of them will have enough psychic power to know why you did something the way that you did.
If you post a copy of your db then at least some other members, without any psychic powers may be able to make some guesses

[Micron]

I advocate basing forms on queries because
- I can test the query before wasting my time on a form that won't work
- I can easily filter the query rather than using form properties to filter. I have never been able to find out if a form filter a) reprocesses the recordset or b) pulls in the entire set but only shows you what the filter allows. Either way, I see those options as being less efficient than loading a form with a query whose records have already been filtered.
- I can easily sort the query
- I can include more than one table (mostly for when the form isn't for editing). There is a widespread notion of 1 form per table/query.

Why you did one or the other isn't that important, but could have been due to your own development if the query one came later.

[Tuckejam]

Sorry Bob, I should have phrased that differently. (and unfortunately the time I can devote to this stuff is usually between 3am and 6am, I am not always fully caffeinated and sharp)

I wasn't asking anyone why I set it up that way.

I was just recognizing that I Had set it up two different ways, and wondering what the difference was between the two different ways