forms

[themebuddies]

I created a test database with 3 tables. I set up the relationships across the 3 tables. So it looks like this



I want to make a form that will input the data. When I create the form and view it. It's blank. From my reading, I can see the reason that it's blank is because there is no data in any of the tables. This is currently an empty test database. How do I make a form that will allow me to start inputting data into the blank database? I do not have any queries set up.

[cbende2]

Do you mind posting the DB so I can take a look?

[cbende2]

Make sure for your form, you want to have these fields on it: [PurchaseOrderID], [Purchase Order], [Cleared By], [Date Received], [Date Cleared], [PurchaseOrderFK], [Line number], [PurchaseOrderFK]. Also, try your best not to use spaces in field names.

[themebuddies]

I have tried attaching files to this site and it never works. It says the file size limit is 500kb. My empty database with 3 tables and one form is larger than that.

I used the form wizard to make the form and it does contain those fields that you posted. when i open up the form in design view. This is what is in the record source field on the data tab for the form

SELECT [tblPurchaseOrders].[Purchase Order], [tblLines].[Line number], [tblDate].[Date Recieved], [tblDate].[Date Cleared], [tblPurchaseOrders].[Cleared By] FROM (tblPurchaseOrders INNER JOIN tblLines ON [tblPurchaseOrders].[PurchaseOrderID] =[tblLines].[PurchaseOrderFK]) INNER JOIN tblDate ON [tblPurchaseOrders].[PurchaseOrderID] =[tblDate].[PurchaseOrderFK];

[cbende2]

I'm not great with SQL and figuring out what's wrong or not, but if you post it, I should be able to figure it out =]

To attach the database, just create a folder, copy and paste the database into the folder, make the folder zipped, and then you can attach it!

[themebuddies]

That worked. I have attached the database

[cbende2]

Hmm ok can you give me an example of how you would like it to display in a form? like so:

Purchase order ID: 1
Purchase order: $100
Line Number: ??? (what goes here)
Date received: 12/16/2014
Date Cleared: 12/17/2014
Cleared by: Cory

[themebuddies]

Purchase order: 4500123456
Line Number: 10
Date received: 12/16/2014
Date Cleared: 12/17/2014
Cleared by: Cory

The purpose of the form was to input the data. I found the PO field has a currency setting applied. That should be text. So was playing with the form a little more and made a button to click to insert a new record once the data was put it. but the form doesn't seem to take input yet.

[cbende2]

Ok, I'll check it I'm a bit!

[cbende2]

Why can't this all be stored in one table? I'm not really seeing any reason to have this in three separate tables.

[themebuddies]

because it was my understanding that if you have data that can be more than one, it should have it's own table. So each purchase order can have many line items. It can also have more than one date. That is why I have a line items table and a date table.

[cbende2]

New folder.zip

You needed to add a table that joins the records of tblDate and tblLines. Check out the relationships I created and think through it. I actually had to brush up my memory on this! Thanks for the exercise

[cbende2]

The form I created doesn't allow more than one entry/display for a certain order, I can create you one that will display the information accordingly though =]

[themebuddies]

I don't get it. I just saw the form you attached and it does the same thing. how do I get it to allow me to insert the data?

[cbende2]

Ok actually I was completely wrong. You had it set up correct... lol, What you needed to do was set up two sub forms in your original form.