I have a many-to-many relationship between Outings (with a primary key of EventID) and Members (with a primary key of MemberID). There is a table that ties the...

Each of my two tables has the same data except the last five fields which are different. I'm simply trying to combine the tables for a Report by joining the...

Hi All, I just wanted to see if the design of some fields in the table are standard practice. The database admin set up a Code_Desc table with fields...

I've been trying to find this answer in the Help and in the forums, but must be using the wrong terminology. My form has a drop down field called "1." and a...

Hi all, I want to enforce referential integrity between two fields in two separate tables: tbl FishTaxonomy (includes the full name, common name, and...

I recently posted a question about multipe M:M relationship tables. In one reply, RPW responded with the following: ************* Although the following is...

I'm new to Access and really don't even know how to ask what I need to know, but I'll give it a shot and maybe you brilliant folks can figure out what I...

I need help in creating a solid table structure for tracking vehicle waivers. I posted this before, but I cannot find the related post. I will try to give as...

Hi, I need a table which will hold a user's answers to about 27 survey questions. Multiple users will use the database to enter responses for each question....

Hi all, I have two tables each is unique. One is the "Merit Badge" tabel the other "person Id" (name address info) tabel, there is a link tabel...

Hi all, I got table in my database with name "tbldata" and i have two fields in that table with the name "Ticket_No" and "Amount". In "Ticket_No" filed column...

I am trying to set up a database to track Girl Guide leaders in my Region along with their training and awards history. Each leader has another leader as a...

Please send me details regarding cardinality and Multiplicity in DBMS

I developed a table that includes 245 records (competitors) for an upcoming Taekwondo Tournament. Along with the table I also developed a form, query and...

i keep questions in a table, each question has a different answer type. eg answer could be a number then there will be limits for the answer or it could be...

I know this might seem technically wrong and therefore, I haven’t found advice on how to do it on these postings. I have an Access 03 table...

So my company just bought another company and they send me a flat text file with 1.5 million records of customer name/orders/transactions etc - all in one...

I have an Access data base that has acumulated 7 years of HR info. We plan to moving this info to HR Application. The new application has a field called field...

I have a table named Items, in this table the items are defined by Name, Size, and Format. When first setting up the table I added a few of my items to get...

I want to achieve (in Access 2003) what the built-in function in Access 2007 does by allowing users to select multiple items in a combo box or list box. See...