Help with project

  • Thread starter Thread starter ryan.fitzpatrick3
  • Start date Start date
R

ryan.fitzpatrick3

If anyone has free time can you help me with my table relationships in
my project to see if they are correct, and possibly give me some
helpful advice on what to do next? I've been working on a database, I
have a form with multiple subforms on it, and I would appreciate help
on the joins to see if they either make sense or work. Anyone want to
take a look? I can explain more in detail later. Thanks in advance.

Ryan
 
Ryan,

These newsgroups are dedicated to helping each other with specic problems
and sharing information. Part of the concept is that when a question is
asked and answered, it should all be done in the groups so others looking for
similar answers can find them.

It is not likely you will find anyone who would have the time to assist you
at no charge. What you are asking could be time consuming. I would suggest
you try to find a competent Access professional and engage his/her services
for some consulting advice. Many of use are in the business of providing
such services, so you would essentially be asking someone to work for free.
And, of course, you get what you pay for <g>

Please understand I am not admonishing your, I am only trying to provide
useful information to you.

If you have specic questions or want to post a request for professional
help, please post back.

Best of Luck to you.
 
I understand what you're saying and I know you are not admonishing
what question. I knew that these groups are for questions and answers,
but I thought I would try and ask anyways. Thanks for your insight.
I'll go back to asking specific questions.

Ryan
 
Okay, great.
Here is a hint on how to ask about your table relationships.
Post a message with the name of each table and at least the name and data
type of the table's primary key. Describe how the table will be used and
how, logically, it should relate to other tables. Not in a technical aspect,
but from a business aspect. For exampe:

My tables are:
tblStudent
StudentID - Autonumber
Each record contains demographic information about a student.

tblClass
ClassID - Autonumber
Each record contains information about a specific class we offer

tblSession
SessionID - Autonumber
Eah record contains information about a time and place when a class is taught.

A student can attend any number of classes. How do I set my relationships
up so I can know who is attending which class and when they are attending it?
 
Great thanks. I'll give it a good college try here. I have a main
form, I have so far 3 subforms on that main form,

ingredsubfrom, packsubform, and freightsubform. I have textboxes that
are on the main form that go into tblcomponent which has componentid
as primary key. This table has item # , item description, UOM, and
date. These textboxes are a finished good item, basically this form
will break down that finished good into the 3 segment components
listed earlier.

The ingredsubform has a combo box that has a selection of choices with
a text box to the right of it detailing what percentage of that item
is of the main item, and it has text box to the right of that that has
the cost of that item.

the mainform (component form) looks like this.. The form is the whole
screen divided into 3 vertical segments all the same size, the left
side has the tblcomponent text boxes, the upper middle has the
ingredsubform, the lower middle has the packsubform, and the right has
the freightsubform. fyi

lets say you have a finished good which is a Chocolate Chip Cookie,
item # 300123

the ingredsubform combo box selections would be a list of ingredients,
so the sub component form layout would look like this:

flour 40% $3.45
sugar 18% $2.56
chocolate chips 14% $1.22
etc, etc

the packaging sub form is the same layout as the ingredient layout
except that the combo box has packaging components.

plastic container 1 $.06
label 1 $.005
etc, etc (quantities are in units not % like ingred)

the freight is alittle different, but I have it where it works, I have
a subform that has a list of criteria

freight $, freight fuel $, zip code, total del cost, and I have a
combobox that has 10 different divisions that we deliver to, I can
make 10 different freight components for the 10 different divisions
for that one item. I got this to work properly ( at least I think so).

The tables look like this

the main form is tblcomponent with componentID as primary
ingredsubform is stblcomponent with histID as primary
freightsubform is tblfrieght with freightID as primary

all of these are one to many relationships and cascading.

i have another one to many relationship to a table that is
tblcomponentsupplier, basically I want this table to be the supplier
and the item together, because this item can have multiple suppliers
or have the ability to have other suppliers in the future.

This tblcomponentsupplier is one to many linked to tblsupplier which
has the supplier information, supplier #, name, etc.

I'm having trouble where to put in the supplier name and supplier #.
The left side of the form which has the item #, name, date, UOM, etc,
lets say item # 1000001 (chocolate chip cookies) I enter in all the
information needed, and all the ingred/pack/freight components, now if
I wanted to add a supplier only to the matter and not change anything
else where would I put this? I've tried making a supplier sub form and
putting the ingredientsubform in that supplier sub form so I can add a
new supplier to those ingredients, but I couldn't get that to work for
me. Does this make sense? I don't want to put supplier information on
the tblcomponent because I would have to re-enter all the information
of that same item for a new vendor, I'd rather just have the
information all present and add a new supplier to the mix.

also going one step further for each ingred/pack component subform I
need to track cost changes, so when that suppiler gives me a cost
change I can input the new prices next to the ingred/pack components
(which are listed already, the flour, sugar, chocolate chips, etc) and
the old prices are saved for side by side comparisions. So with the
stblcomponents (ingredsubform) that has histID as primary, I created
another table to track the cost changes I named that tblUnitpricing
with componentpriceID as primary.

in tblunit pricing I have

ComponentPriceID
HistID
pricechange (new price)
date (date entered)

I link through histID. My issue with this is how do I get this new
information into componentpriceID? Do I make a new form for this, if
ingredsubtable has

flour 40% $3.45
sugar 18% $2.56
chocolate chips 14% $1.22
etc, etc

already in it, do I add a button at the button saying "new price" and
open up a new form to enter in this data? Would it have to be the same
format combo box, text box, text box? Is there away to have the flour,
sugar, chocolate chips, carry over into the new form and the price
text box be blank, where I can type in new prices and it goes into the
tblunitprice? Sorry for the long description. Thanks in advance. Does
this make sense? I imagine I'm a little out of my league on this one.

Ryan
 
Back
Top