I am using a simple form for the user to enter data into the main table. one of the fields available is "Box Number" and each of these boxes holds 16 items....

I created 5 Tables: 1)Office with Primary Key as auto number named Office ID 2)Marketer with Primary Key as auto number named Marketer ID 3)Currency with...

I have been reading all about the evils of lookups in tables, however could someone please explain how you avoid using them - is the answer to have many tiny...

Win 7, access 2007 , tables: device and ip, relation (device.ipIP, foreign)one-to-one(ip.ID, primary) when I delete an device from device table using form it...

Hi all, We have just made the transfer to Access 2007. Apart from the ribbon layout, which I believe only requires some time to get used to, I have a question...

It sounds like both Employee and Training are one to many with Completed Training However since you might want to tracj scheduled training (not yet complete)...

I'd like to create a table that has two/three fields. 1) a description of what the linked file is and 2) the hyperlink to the file. I'll have one more field...

Dear All, In northwind database that comes with access 2003, how can I make a form for purchase / received inventory just like customer order, form for this...

Existing I have the following table structure (in Excel) and now want to have better control by using ACCESS. SC no Buyer PC no Supplier...

I'm creating a database of text fields. I expect some data to exceed 255 characters. What is the maximum field size of a text field? Can I increase the text...

Office 2007, just upgraded from 2000 ( OMGOODNESS!! What a flippin' NIGHTMARE!!) I am simply trying to import a tab delimited text file into an existing...

Here is my challenge. My work has a wretched almost unsearchable "database". I am trying to cobble together my own relational database from that...

Every now and then, some or all of the database objects that i have assigned to "custom groups" get unassigned and appear in the "unasgined objects" group....

I am setting up a job number database for my company. As of now the "database" is kept in a binder. It will soon be housed on our server. Yay! The most...

I am currently designing a database that will be used on a LAN and a number of remote laptops that may or may not have access to the internet. I would like to...

I have a table that lists employee names, employee ID, Badge numbers and other info on the employee. This table is used in multiple queries. When employees...

I have created a couple of Dbs which the table structure seemed to simply fall into place, it was just logical in my head. That said, I am working on a new...

Ok after reading some of the feedback, I went back and redesigned my tables. In addition, here is an overview of what I want this database to do. 1. Tel me...

I want to add a child table to my table and using one of the primary key of the table. For example: MyTable is PKey1 PKey2 PKey3

I am a self-taught novice (the worst kind!) so am hoping I can get a nice simple answer to my question. First the history: I want to re-build a database...