F
FirebirdGM
Alright, I have numerous questions regarding the creation of a
relational database system with Microsoft Access.
1) Lets say I have the following fields in a table named Customers:
FirstName
LastName
Address
CreditCard
How would I create a form/query which had a text box, where I could
enter a name, and it would search by FirstName field? Obviously, I
would need a query to do a 'WHERE" statement, but I don't know how to
set the WHERE Clause to a text box on the form. :|
2) This comes moreso into play with the relationalness.
Lets say I have two tables:
LOCKERS
LockerID
Renter
CUSTOMERS
Name
LockerID
Renter
Is there a way which I can link the two 'LockerID' and 'Renter'
together, so that one would read the data from the other one, and
update accordingly?
Thanks.
relational database system with Microsoft Access.
1) Lets say I have the following fields in a table named Customers:
FirstName
LastName
Address
CreditCard
How would I create a form/query which had a text box, where I could
enter a name, and it would search by FirstName field? Obviously, I
would need a query to do a 'WHERE" statement, but I don't know how to
set the WHERE Clause to a text box on the form. :|
2) This comes moreso into play with the relationalness.
Lets say I have two tables:
LOCKERS
LockerID
Renter
CUSTOMERS
Name
LockerID
Renter
Is there a way which I can link the two 'LockerID' and 'Renter'
together, so that one would read the data from the other one, and
update accordingly?
Thanks.