One-to-many relationship need entry on the many side?
Tue, 9 Sep 2008 16:05:01 -0700
Would it violate referential integrity to, for test reasons, input entries
into the "one" side without at least one entry on the "many" side? Thanks!
...
|
Designing event database
Tue, 9 Sep 2008 13:50:01 -0700
Hello, I am trying to design a database that produces reports on an event
log. The table is automatically populated by a different program when I
perform
analysis runs on satellite collision avoidance - basically whether any of our
satellites are getting close to something else floating around out there and ...
|
Choosing a Currency Rate for 1 table based on field in another tab
Tue, 9 Sep 2008 10:36:04 -0700
Currency fields do not allow lookup values.
Each piece of equipment will have a rate attached to it.
The equipment used is chosen from "Equipment" Table as a lookup column.
The equipment used is stored in "Applications" Table.
The rate is stored in a "Pricing" Table.
Can I have the rate field in the Prici ...
|
Combo Box Look up
Tue, 09 Sep 2008 14:52:25 GMT
I have a Combo Box that lists Names. Each name can be in there twice. There
is a Id and a time id that identifies each record. How can I choose a
record from the combo box based on 2 identifers ?
For example, I would like to choose id 20 with time id =2 and have that
information display in the form...etc.
...
|
How to insert fields of different tables in one form?
Tue, 9 Sep 2008 04:46:00 -0700
Suppose I create two tables to store information. I want to desing a form
where I can have the fields of both tables. I want to know how to access the
fields of these two tables in the same form? ...
|
Circuitous Relationship
Mon, 8 Sep 2008 20:40:01 -0700
I assume that I'm dealing with a circuitous relationship problem since I
can't seem to resolve what is occuring. I am rebuilding a training database
for the military. Here is the structure I have thus far:
CrewInformation (contains basic member data)
Schools (contains information about the schools/NECs)
S ...
|
Record Validation?? for newbie
Mon, 8 Sep 2008 11:36:01 -0700
I have designed a database in Access 2003 which we will use for scheduling.
I am looking for the best solution to identify duplicate fields within the
same record. The values in the work location fields will come from an
employee table using lookup. I just want to have some type of msgbox showing
the pers ...
|
|
|
adding products to an order form
Mon, 8 Sep 2008 11:07:01 -0700
i have a table listing products
I have a continual form with all the products and its information
I would like to make it so that when I enter the qty to be ordered on the
products form it adds the product and qty to the customers order form.
how do i do this. ...
|
Access 2003
Mon, 8 Sep 2008 05:54:01 -0700
I am using access 2003 and I do not recall some of the codes to use in the
table format so that I can use exclusive info designated for that item in a
particular column.
I know there were codes such as "like", as etc....
Is there a place I can find those codes... or can you walk me thru ...
|
My welcoming scrolling words does not work
Sun, 7 Sep 2008 23:38:00 -0700
Hello,
I have Access 2003 and 2007 in my computer. When I created my database was
in Access2003 because my church membership will be distributed to many
churches that mgiht have older version then 2007.
Before it can work in 2003, but now since anytime I open it by default it
was opened by Access 2007, t ...
|
