Access Form

[shearne]

I am very new to Access and have only taken one class that taught basics.

I created a new database containing a number of tables, each important for the purpose of this database (to create a functional project data sheet). Examples of a few of the tables are Architect, Client, Project Name, Project Details, ect.

After creating the tables and connecting them via relationships I then created a form via form design utilizing everything from each of the tables.

Everything seemed to be fine until I tried to enter data into the text box. It only allows me to enter data into about the second half of the form.

Am I complicating things by using too many tables? If i just use one the information would make it incredibly large and we need it to be detailed (this is why we are using many tables thus far)


If anyone can help, it would be greatly appreciated. Thank you very much!

 

[adfeds]

Quick comment is that each form, if I am correct and I am not an expert, but each form should be updating one table. You can use subforms to populate additional tables. Just wondering if that is why the first part of the forms are static.

 

[Cronk]

Post the recordsource for the form.

 

[missinglinq]

...but each form should be updating one table. You can use subforms to populate additional tables...

That's correct. Many multi-tables Queries are partially or completely Read-Only. Here is a fairly simplified example of a Main Form/Subform scenario, where customers can place multiple orders, and each order can have multiple items:

CustomerTable

CustomerID 'Primary Key
CustomerFirstName
CustomerLastName
CustomerHomePhone
Customer CellPhone
CustomerStreetAddress
CustomerCity
CustomerPostalCode
...and so forth

OrdersTable

OrdersID 'Primary Key
CustomerID 'Foreign Key
OrderDate
MethodOfPayment
...and so forth

OrderItemsTable

OrderItemsID 'Primary Key
OrdersID 'Foreign Key
ItemName
ItemQuantity
ItemCostPerUnit
...and so forth

Notice that the Tables 'cascade'

• The Primary Key of the first Table becomes the Foreign Key of the second Table
• The Primary Key of the second Table then becomes the Foreign Key of the third Table

To display all of these in one Form and to be able to enter New Records or Edit Existing Records in all of these Tables:

• The Main Form would be based on the CustomerTable
• The first Subform would be based on the OrdersTable and linked to the Main Form by the CustomerID
• The second Subform would be based on the OrderItemsTable and linked to the first Subform by the OrdersID

If the Form looks too crowded, you can place a Tabbed Control on the Main Form and have each Subform on its own Page.

Linq ;0)>