Re: Edit multiple tables with one form per record

Allen, thanks for your reply.
I do have a Store table, I have called it the Store Master Information
where I have the following fields.
Store Number | Store Address | Store Phone Number| etc,.

I understand what you said with the Sale table, however I do not
understand how I can create a form bound to the Sale table.
I don't need to show sales for more than one date at a time. I just
need to be able to enter the information for all the stores in one
screen/form to make it easy to enter information.

Once again, thank you for your help, I appreciate it and now I know
that going to a table per store solution was incorrect. I will have a
Store table which has all the stores and their corresponding
information, and then a Sales table which will have all the sales
information.

I will try to search in my Access book about bounding.

.

Relevant Pages

  • Re: Help PLEASE! Not sure what answer is: Match? Index? Other?
    ... you need what Excel calls a list. ... would contain the name Area, B1 the name Store, C1 would contain the name ... you establish a pivot table. ... type the name of the sales data range -- I suggested SalesData ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Astronomy vendors and their "sales"
    ... their sales continue to dry up. ... electronics store in my area that was closing down a few years back. ... knew Circuit City was going out of business, I decided to make a trek ... Since the economic distress took hold this autumn, liquidators have ...
    (sci.astro.amateur)
  • Re: Thank you with Design Assistance but...
    ... (StoreID in the sales table) ... caused entirely by treating a database as a spreadsheet. ... Also how would I write the queries for, lets say, One Store, week ... the RecordSource for a report so you can pretty up your analysis. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Thank you with Design Assistance but...
    ... Although each Access database is limited to 2G, ... (StoreID in the sales table) ... You saw the simple queries that I ... Also how would I write the queries for, lets say, One Store, week ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Todays Priceless Supermarket Moment
    ... look like they are working hard to keep your business. ... You've never worked in a grocery store, ... waiting to bring in the next customer. ... And most of our sales come from repeat customers. ...
    (rec.food.cooking)