If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Help! Form not working.
Hi,
I just divided a very large table into 3 smaller tables. I believe I have setup the relationships correctly. I'm using a form/subform to enter the data. The subform uses command buttons to open a form with more details. The records that were entered prior to the table conversion is totally accessable, but when I try to enter a new record the form will not allow any information to be entered. Does any one have ideas? TIA, Richard |
#2
|
|||
|
|||
Help! Form not working.
On Mon, 14 Jun 2004 20:06:59 -0700, "Richard Wright"
wrote: Hi, I just divided a very large table into 3 smaller tables. I believe I have setup the relationships correctly. I'm using a form/subform to enter the data. The subform uses command buttons to open a form with more details. The records that were entered prior to the table conversion is totally accessable, but when I try to enter a new record the form will not allow any information to be entered. Please post the SQL view of the two forms' Recordsources, the subform's Master/Child Link Fields, and the error message that you're getting. John W. Vinson[MVP] Come for live chats every Tuesday and Thursday http://go.compuserve.com/msdevapps?loc=us&access=public |
#3
|
|||
|
|||
Help! Form not working.
Hi John,
Thanks for the help. I do not know or understand what you mean by sql view of the two forms' recordsources, but if you will tell me how to obtain it I be happy to provide the info. The subform's master/child link fields are both set to AddressID. I do not receive an error message, the called form just displays with the cursor blinking in a field, but doesn't accept any input. My table breakdown is as follows: Table: Address Table: Customers Table: RoofInfo ---------------------------------------------------------------------------- --------------------- PK: AddressID PK: CustomerID PK: RoofID Common Field: AddressID Common Field: RoofID Relationship: Tbl:Address/AddressID One to Many with TBL:Customers/AddressID and Tbl:Customers/RoofID One to One with Tbl:RoofInfo/RoofID. My Master Form's recordsource is the address table. The child form's record source is the customers table. On the child form I have to cmd buttons. One button opens a form called customer that allows more details to be entered and it's record source is a query combining info from all 3 tables. The second cmd button opens a form called roofinfo which allows details about a properties roof to be entered. This form's record source is the same query. What I am trying to do: I need to track a single property address that might have multiple customers, with each customer linked to the same roof, but with different types of info about the roof for each customer. My Master form shows the address and date the property was entered into the database (stored in the address table) . The child form shows the contact name, company and scheduled date of inspection. The user will then select either the button to enter more details about the customer or the button to enter details about the property's roof. I can view/edit data that was previously entered and I can enter new data in the master/child forms, but when I try to enter new data in the forms called by the cmd buttons nothing is accepted. FYI - I've noticed that the primary key fields for the tables address and customers is updated when I enter data into the master/child forms, but the primary key field in the roofinfo table is not when I open the roofinfo form. TIA, Richard I hope this clears up what I'm trying to do. "John Vinson" wrote in message ... On Mon, 14 Jun 2004 20:06:59 -0700, "Richard Wright" wrote: Hi, I just divided a very large table into 3 smaller tables. I believe I have setup the relationships correctly. I'm using a form/subform to enter the data. The subform uses command buttons to open a form with more details. The records that were entered prior to the table conversion is totally accessable, but when I try to enter a new record the form will not allow any information to be entered. Please post the SQL view of the two forms' Recordsources, the subform's Master/Child Link Fields, and the error message that you're getting. John W. Vinson[MVP] Come for live chats every Tuesday and Thursday http://go.compuserve.com/msdevapps?loc=us&access=public |
Thread Tools | |
Display Modes | |
|
|