Design question about tables
Fri, 5 Sep 2008 07:26:01 -0700
Hi, I have been trying to learn database design for quite a while now. I
never seem to have a block of time to devote to it though. I am back at it
after a long hiatus. One question I have never seen addressed is:
Why in RELATIONSHIPS is there sometimes a second table listed? That is, if
you have an EMPLOYE ...
|
Unclear on Design
Fri, 5 Sep 2008 07:03:00 -0700
I am looking to have a form with a problem listed. In this form I would like
there to be a subform that lists the notes by a user that enters data via a
text box.
IE. 9/5/08 Customer Called,
9/6/08 Replacement sent to customer etc.
Questions are:
1. How does this work as each record could have multipl ...
|
Invoicing database design
Fri, 5 Sep 2008 06:48:22 -0700
I am redesigning an existing database and need to put some invoicing
capabilities in it need to carry forward some payments an credits to the next
invoice. the existing database was a simple one table database to store info
for the amount of credit cards that we need to reimburse our customers. Now
we are se ...
|
Form Control Properties
Fri, 5 Sep 2008 05:38:09 -0700
Should I set the properties when creating the tables, or should i sset the
properties when I creating the forms. And if you have the same properties on
tables and on forms, do you need to ensure the properties are set on both the
table and the form? ...
|
Chopard Happy Sport 18kt Gold Ladies Watch 27/6851-23 Recommendation
Discount Watches
Fri, 5 Sep 2008 02:13:15 -0700 (PDT)
Chopard Happy Sport 18kt Gold Ladies Watch 27/6851-23 Recommendation
Discount Watches
Chopard Happy Sport 18kt Gold Ladies Watch 27/6851-23 Site:
http://chopard-watches.pxhelp.com/Chopard-wristwatch-1658.html
Thank you for choosing http://www.pxhelp.com/
Quality Chopard Watches: http://chopard-watches.pxh ...
|
no relations when importing xsd schema file
Fri, 5 Sep 2008 00:21:01 -0700
hello,
I have a schema of a database with 2 tables: a master and a detail table.
The relation between both is defined.
I want to access to build those table plus their relationsship.
I set up an empty database in ms access 2003 or 2007 and then use the
option: external tools.
This options allows open ...
|
FIFO Help
Thu, 04 Sep 2008 21:42:57 GMT
Hi All,
I am working on a scheduling program. We need to schedule shipments of orders
and pull from stock. The orders would be in a FIFO method or First In First
Out basis. The first order in for an item, if the item is in stock that order
will ship. The thing I am struggling with is orders with multiple items ...
|
|
|
Question about Access DB design and related fields
Thu, 4 Sep 2008 13:38:01 -0700
Access 2000 for Web Application
I am starting a new project and have a db setup question if anyone could
help me. With this project we are going to be tracking several Topic with
suptopics for each employee. I am trying to setup the most efficient way to
set these up in the DB and to also make it easiest for ...
|
Database Design & Form due to Brain Block
Thu, 4 Sep 2008 12:11:00 -0700
I have been working on this for the past few days and now have total Brain
Block. I want to create a database that has a customer (name & account #,
workorder (WO #, date, amount), labor code (code, description, and billing
rate) tables. I can create the tables, but my problem is building the form
that let' ...
|
Error 3197
Thu, 4 Sep 2008 12:07:02 -0700
The error message box reads:
Error 3197 "Write Conflict"
This record has been changed by another user since you started editing it.
If you save the record, you will overwrite the changes the other user made.
Copy the changes to the clipboard will let you look at the values the other
user entered, and th ...
|