Re: Edit multiple tables with one form per record

ricky.agrawal@xxxxxxxxx wrote:
>Salad, thanks for your reply!
>I have created one table rather than 30 or so for each store. It is
>much simplier to have one table for multiple reasons.
>
>I think I have figured out a way to have only specified dates appear.
>To use the filters!
>
>I can simply apply a filter of 9/25/2005 and only those records with
>those corresponding dates will come up!
>
>The only problem I can see with what I have created so far is skipping
>a store. However I can run a query later on to display a list of the
>stores and their latest data entry. I'll have to figure out how to do
>that (I haven't even look yet).
>
>Or should I create a form with all thirty stores information displayed
>without the STOREID drop down box so that folks know which stores have
>their information entered in or not?


What salad said .. and a simple way of limiting to just the one date is to
create a form with no recordsource and on it put a control for entering the
date you want to view or edit. Then add a sub-form - the sub-form record
source would be the sales table. The sub-form control properties would be

Link Child Fields = SalesDate
Link Master Fields = controlDateOnMainForm

Now only the records with that date show, and any added records default to
that date. This form design is easy and assumes you really only want to
enter / show records for one date at a time ;-)

If you want you can add a command button that adds runs an append query to
add a new record for each store with the date set to the date on
controlDateOnMainForm - this way you can just fill in the values for each
store and won't have to wonder if you missed any stores. If a store had no
sales you would delete that stores sales record.

Roger

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/200512/1
.