Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Need to find a simple template

Status
Not open for further replies.

GeorgePal

MIS
Oct 14, 2002
57
0
0
GR
I want to create a dbase to store supplies and products. Each supplier can be supplier of lots of products and each product might be supplied by more than one supplier.
Furthemore, i want to be able to enter additional information for the product or the supplier.

Do you know if it is possible to find on the net such a template to download??

Thank u!
 
I have a purchasing system that does that. The relevant table for your purposes is what I call the "PriceBook". It is a table of the form
[tt]
PriceBook

SupplierID (PK) FK to Supplier Table
StockID (PK) FK to Stock Master Table
Price
SupplierStockCode
SupplierProductDescription
... Other Fields ...
[/tt]
You can add or remove fields as appropriate for your application.
 
Yeah but how can i have it ready in my dbase instead of creating it from scratch
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top