Database Problems- Help Me Please

M

Mel

i have downloaded the database l'ending library' and when i go to open the
check out form a msg comes up saying "check out is not designed to be opened
without a filter"

Any Help would be appriciated

Mel
 
B

Brendan Reynolds

Mel said:
i have downloaded the database l'ending library' and when i go to open the
check out form a msg comes up saying "check out is not designed to be
opened
without a filter"

Any Help would be appriciated

Mel
Click to expand...


That form is not designed to be opened directly from the navigation pane,
it's designed to be opened from other forms, for example by clicking in the
Action column in the Asset List form. You'll also need to enter some asset
data first, as the form won't work well if there are no records in the
Assets table.
 
M

Mel

THANKYOU for your help it was more helpful then the last person that replied
to my earlier post. i was also wondering in the asset list there is and
owners column and it add the details added in it to the contact list. i was
wondering if there is a way to send these details to an owners table(if i add
one) so i can use the contact list to show only the people that borrow our
items
 
B

Brendan Reynolds

You don't need another table, you just need a query that joins the Contacts
table to the Current Transactions query. If you look at the existing query
called Assets with Transactions, that shows how do do it, you just need to
join Contacts and Current Transactions instead of Assets and Current
Transactions.
 
Top