two questions: table question and Is there away to link an outsidedocument to access

[ryan.fitzpatrick3]

I'm not sure if this is possible; I have a database currently that
lists all of our products with related information. First I have a
query that downloads information from a table, I need to update this
once a month to capture newly added information like new product #'s.
Also with this new data I need to create new table fields so a user,
on a form can enter in information that will download to the table
which is tied to a product and supplier. How do I create a table that
I can update information while keeping the same input data from the
user form? Here's what is downloaded

Product #, Product Name, Buyer, Location, Supplier

I need to add these fields to the table so I can put in the form

Contact name, contact phone, COOL origin

so in the form, it should look like


Product #, Product Name, Buyer, Location, Supplier, Contact name,
contact phone, COOL origin

whereas the Product #, Product Name, Buyer, Location is all is
automatically shown on the form details and a user can enter in
Contact name, contact phone, COOL origin manually for the respective
product and supplier. Make sense? So if you open up the form it'll
look like this

Product #, Product Name, Buyer, Location, Supplier, Contact name,
contact phone, COOL origin

1213456, Spoon, Tom, 8162, Spoon Supply,
blank, blank, blank
1213457, Knife, Tom, 8162, Knife Supply,
blank, blank, blank
1213458, Cups, Tom, 8162, Cups Supply,
blank, blank, blank

The supplier now gives us Contact name, contact phone, COOL origin
information from where they get their product from, a user can now
enter that data in for the supplier and product that they sell. so
it'll look like this.

1213456, Spoon, Tom, 8162, Spoon Supply,
Joe, 555-456-8745, China
1213457, Knife, Tom, 8162, Knife Supply,
blank, blank, blank
1213458, Cups, Tom, 8162, Cups Supply,
blank, blank, blank

Then all of it will save to a table and I can run an append query or
whatever and capture new products/suppliers and still keep all of the
information.

2nd question.

If I have a document of a supplier is there away to store it in access
or wherever and have access call upon it, lets say I click the
supplier and access brings up all related documents to it?

 

[NTC]

aspects of your question are confusing; the term 'download' is not a database
term.... when you have a query it is looking at a subset of data from a table
or multiple tables; if the query allows one to update the data - you are
changing data directly in the table...

likewise; one does not add 'fields' dynamically on the fly; table fields
should be fundamentally planned and created once only as part of your overall
db design...perhaps you mean adding data to existing blank fields....

it seems like you are in need of a form with the primary data and a linked
sub form/table; but it difficult to be more specific

As to question 2: you can create hyperlink fields in a table...and put in
these the path link to other documents related to the record. Hyperlink is a
field type, just like text, date, number etc...you should look this up in the
Help for more info.

 

[ryan.fitzpatrick3]

thanks, I figured out my first question, it is sorta hard to explain,
but I got it. I'll check on hyperlinking. Thanks again.