At 09:49 AM 8/3/2014, TOM HART wrote:
I am refining my database and have a question about a form. I have
a table of inventory with a primary key item number. For a sale I
create a form with a temp table and select the data based on the
item number using the variables in the form(each column from the
inventory table where item number = item number. I have been using
this for years and works great, but, would it be better,faster, etc
is I populated the columns using the select command. Just wondering
Tom,
There is always a better technique in doing anything today. That
is just the nature of evolution, and if you would like to keep
your application on top, use what R:BASE has to offer today.
There are soooo many coool options and techniques ...
If your goal is to simply display and reveal all related items
based on an item in a table with Primary Key, you can define a
variable form with Variable Lookup ListView controls to achieve
your goal.
However, to create a new Sales Order, take a look at the entire
process and techniques used in "Enter New Sales Order" in the
sample RRBYW18 database/application.
Hope that helps!
Very Best R:egards,
Razzak.
www.rbase.com
www.facebook.com/rbase
--
31 years of continuous innovation!
16 Years of R:BASE Technologies, Inc. making R:BASE what it is today!
--
--- RBASE-L
================================================
TO POST A MESSAGE TO ALL MEMBERS:
Send a plain text email to [email protected]
(Don't use any of these words as your Subject:
INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: INTRO
================================================
TO UNSUBSCRIBE:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: UNSUBSCRIBE
================================================
TO SEARCH ARCHIVES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: SEARCH-n
(where n is the number of days). In the message body,
place any
text to search for.
================================================
