Form for Multiple Company $$ Rates

[CherryBomb]

I am creating a Form using a table. It has the following columns

Company Name
Date of Entry
PO #
Ship
Rate
Notes

What I need to do is one company will be listed 15-20 times. I need to combine all of the information for each company. There will be multiple companies though.

Example:

Company 1
Date of Entry: 06-05-11
PO #: 123456
Ship: A
Rate: $50
Notes: None

Company 1
Date of Entry: 12-22-10
PO #: 354894
Ship: B
Rate: $150
Notes: blah blah bah.

Company 1
Date of Entry: 09-16-11
PO #: 579641
Ship: A
Rate: $75
Notes: None

That kind of theme, but there will be more than one company - I just want to be able to group all the info. for each company cause there are multiple rates/info I want to have together.

 

[John Big Booty]

You will need two tables. One will be your Company Header Table and might look something like;

TBL_CompanyHdr
CompanyID (PK)
CompanYName
CompanyAddress

This table will hold the static company information that does not change.

Your second will hold your shipping details, and might look something like;

TBL_CompanyShipDtls
RateID (PK)
CompanyID (FK)
Date of Entry
PO #
Ship
Rate
Notes

The table can then be kept synchronised by using a Form Sub-Form set, the two tables being linked via the common key CopmanyID.

 

[CherryBomb]

John,

What does (PK) and (FK) mean?

 

[MSAccessRookie]

John,

What does (PK) and (FK) mean?

I know I am not John, but I can answer the question for you.

PK (Primary Key) refers to a Field in the current Table, and FK (Foreign Key) refers to a Field in another Table (Which itself is normally the Primary Key of the Table) that are used to Join the Tables together and obtain the related Information.

 

[CherryBomb]

Thanks so much Rookie

Maybe one of you can assist me with the next part to this?

I have now created the Subform inside the Mainform and I would like to .... hmm how can I explain this ...

I want to show multiple records at once in the Subform. Instead of clicking through to see the various records, I want to form to show them all at once, but not in the table format - I would like to keep it in the Form format.

Any ideas?

 

[MSAccessRookie]

Thanks so much Rookie

Maybe one of you can assist me with the next part to this?

I have now created the Subform inside the Mainform and I would like to .... hmm how can I explain this ...

I want to show multiple records at once in the Subform. Instead of clicking through to see the various records, I want to form to show them all at once, but not in the table format - I would like to keep it in the Form format.

Any ideas?

What you see when you open a Form is controlled by the Form/SubForm Default View property. What you call Table Format is probably the DataSheet View. Other options include Single Form, Continuous Form, and Pivot Table Related Forms. You will need to look at each of them to determine which one you want, but I suspect that Continuous Form might serve your purposes.

 

[CherryBomb]

Rookie,

After tinkering with it - I found that option. Thanks so much for your help. Now I am trying to just get the format right and the size of all the forms and data sections to align right. I think this seems to be the most challenging part. haha.

 

[MSAccessRookie]

Rookie,

After tinkering with it - I found that option. Thanks so much for your help. Now I am trying to just get the format right and the size of all the forms and data sections to align right. I think this seems to be the most challenging part. haha.

Good to hear that it is working out for you.

 

[CherryBomb]

One last question about the form, when I exit it and try to re-open it - it asks me to put in the Supplier ID# - I don't want it to do that. How do I cancel that option?

 

[MSAccessRookie]

Is your form based on a Query or a hard coded SQL Statement? Perhaps there is an error inthe spelling of one of the fields.


****************************************

Did you remove a post regarding a problem with your Sub-Form? I got an Email about it, but do not see the problem here.

 

[CherryBomb]

I did removed a post, I had figured it out

In regards to the other problem you were exactly right, I had changed the header name and it had created that problem. Thanks! It is fixed now.