Hi, I have a database full of names (for geneology) where I have Last, First, Middle and Title. My table has an auto-number for primary key. From reading...

Hi Folks - Not too familiar with using composite keys as a primary key ... If I have a 2 field composite key in a table, say lastname and firstname, do I...

In one of the tables in a db, I've tried to prevent duplicate records by creating a compound index--but it's not working as I hoped. The table contains a...

Hello everyone, I need to know if it is possible to index a combination of fields in a table. For example: &

Design question: When is it necessary to create a compound primary key in a child table? For example. I am working on a database that records information about...

I have a table where the uniqueness is based upon three fields. One field is numeric (integer) and the other two are text. I really don't want to make a 3...

I've made a lookup table with a primary key based on age and total score (if the test taker is a certain age and scores a certain total score, various other...

I'm creating a table to hold conference call minutes. Each call must have exactly one Study, exactly one CallType, and exactly one CallDate. I'm torn between...

Hi, I am trying to create a database to store all the computer information at the school I work in. I have the fields Building, Room, Staff, Subject,...

Hi All I'm trying to design a computer inventory program with VB6 using Access as a backend. I have the follwing tables so...

Hi All I volunteer at my local library. I'd like to create a computer inventory program using VB6 as a front end. I have tables for Locations, Computers,...

In my db I have querries creating a consisting of concatenated fields, ie; +Right(,4) however this concatenated does not appear in the tables. Is there a...

I have an extensive video collection for which I am creating a database. Part of the data I am storing includes a table containing the actors in the videos;...

Hello, I am rather new to building expressions in Access. I have a pretty simple task, really. I want to concatenate values in 'Reach' and 'Station' fields...

Hi, Have looked for this in the forum but with no luck I have two fields in a database 1) Form_No (example value "FT001") 2) Time_Of_Call (example...

Is it possible to make a concatenation of a 3rd field from fields 1 and 2 all in the same table? If so, can I make that 3rd field the primary key? -- Dale

Hello, Got that great double set of Developers Handbooks, but as much as I know about Access I seem to be missing a lot between basics and that offered in the...

Hello, This is the start of a new database adventure for a small manufactoring process. The customer wants to track Inventory 'sold' and 'on-hand' as well...

First, my apologies to this lengthy email, as it seems these news groups are more focused on short-term problems and perhaps my email is inappropriate for this...

I am looking for a template that features (for starters) boxes, aligned horizontally on the page, in which I can list the 5 to 7 phases of...