Drew Jensen wrote:
Girard Aquino wrote:
Basically, what I want to happen is:
- client approaches staff and asks for supply
- staff enters ID number and if
- client already has an entry in database, staff just adds the new
supplies the client needs which goes to the SUPPLIES table
- client is not in database, staff creates a new entry in the
CLIENT table and enters supplies given accordingly.
I created a form using the wizard and set the SUPPLY as a sub-form of
the main form which uses the fields of the CLIENT table (e.g. ID,
FirstName, LastName). Now when I enter data in the ID, say 1234, if
there is an existing entry under the Supplies table that is
associated with the primary key, in this case, ID in the CLIENT
table, the items show up on the form.
What I would like to happen is to have the FirstName and LastName
show up as well when an existing ID is entered in the form that is
already existing in the CLIENT table. It's kinda like a search form,
that tells you when there is an existing entry already. Do i need to
create a separate table that will duplicate the FirstName and
LastName fields so that they show up when an existing ID in entered?
Or should there be a separate form to do "searching" and another one
to enter new data?
Actually you are quite close to having what you want. There is a
problem with your tables with regards to the relationship link between
them but after that most of the functionality you want is already thee
in the Base application.
http://baseanswers.com/downloads/oooSupplies_mailinglist.odb
Hello again Girard,
Well - I hope that you had a chance to look at that database and the
single form in it.
In my last email I said that it was not the 'real' email I wanted to
send - actually it may not be an email I was thinking of at all.
I hope you don't mind but I've used your query to 'prompt myself' into
working on a presentation regarding Base and using your specific
question as the subject.
Putting together the presentation is going to take 'a couple of days' at
least and rather then just let you sit in silence during this time -
I'll put the file on-line and update it as I go.
http://baseanswers.com/downloads/oooSupplies_search_filter.odp
So - I'll be updating the file more tonight and will put another email
here as I update the on-line copy.
But - if you look at it now or later and use it to trigger questions via
the list - then I can answer the questions here and update the
presentation as needed.
Thanks
Drew
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
