Hi I am looking for assistance with design of table.
I need to track Event and Participants.  I understand that I will need an
intersection table to Join Event and Participants since one person can
participate in many events.  Where I am getting stuck is that I also need to

I've read the threads on the above -- and posted this problem in another
user's group -- but still can't get it to work. It's on an intake form for
hospital admission. Tbl structure involved in this part is:
Tbl ReferralSourcesAll

In my database I have a Sales table. The data in this table will be used
to analyze and summarize Sales related info in various reports.
For Cash Memos and Credit Invoices two different serial numbers are
used by the company. Pre-numbered Cash Memos and Credit Invoices are

We have a regional dbA. I was hired to create a new dbB for our location
because my supervisor doesn’t like the interface for dbA.  I believe dbB is a
separate module/entity from dbA and doesn’t need to be related but I have
access to dbA through terminal services.   The ...

I am designing  the new DB for my company, when i get the new order for
customer, sometime they are using inches , but we are using mm for our
factory, i was wondering how can i change the design for my order entry, i
can input inches to conversion mm , when i generate the ...

When I use the Microsoft communities website to view this newsgroup, it shows
up as Access Database Design, but posts I make here do not seem to appear on
OutlookExpress under TableDesign.  How will this newsgroup appear in OE?

I would like some help on running a query from the switchboard, the query is
a pivot chart, I added it to the switchboard with a command button to run the
query.  However it opens the query data returned but I would like it to be
able to open the acutal pivot chart instead as the ...

How do I set up a database where I may  efficiently enter data from a town
survey?  There may be up to 35 questions, some with multiple answers.
Thanks!

I am sure I am looking too deep into this but I have the following data and
can not figure out how to oraganize it so I don't save duplicate data.
This is for Key Traking.
The fields I have are.

3 tables of referral sources and one 'join' table with an ID field common to
all 3 (Resource ID). In Table 1, all items are Resource ID #1; in Table 2,
all items are Resource ID #3; in Table 3, the items are all other Resource ID
#s but ot #1 or #3. I've set the relationships to ...

Hi, this is my scenario: tblClient, tblContract, tblEvent and tblEmployees.
Clients have Contract and Contracts have Events. Example1:
Client=Weddings.com, Contract=December, Event1=Xmas Wed. Example2:
Client=Weddings.com, Contract=December, Event2=New Years Wed. Example3:

I’m having trouble on how to design the tables for my database. Currently I
have 10 locations and they report their revenue each month by classification.
There are 10 different classifications. Now the classifications are also
classified into 5 groups and the classifications can ...

I've noticed when I double click a line in my listbox, that if one of the
fields has a blank value, my INSERT INTO statement bombs out when I
double-click that line.  Why is that???  What do I do so that my INSERT INTO
works when one field on the line is blank/empty?

I'm sure that you've probably guessed why I'm here. I have three
tables, a Person Table, an Item Table and a Sub Item Table. I want to
create a fourth table where I can store which Items a Person has. Only
a few Items have Sub Items, and those that do have Sub Items only have

I want to design a databse that ahndle general ledger like msaccess ledger
template but in that template there is no check handling and bank reconcile
process some can tell me the idea of bank reconcile process with tables