New record [message #461591] |
Sat, 19 June 2010 06:44 |
manisha_borade
Messages: 49 Registered: May 2010
|
Member |
|
|
hi,
i have created form on which 3(trip_date, shift_code, warehouse_code) non database field and some database fields (item_code, recipe_id,-----)
when i fill 3 fields it gives the record corresponding to that
from base table, i create table 'TMS_REC' to save this data(record)
now i want that if user enter same combination of trip_date, shift_code, warehouse_code then it show the record from 'TMS_REC'
and if don't then show the record from base table and clear the record for new combination
please help me
|
|
|
Re: New record [message #461593 is a reply to message #461591] |
Sat, 19 June 2010 08:42 |
|
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
Looks like IF (user enters something) - THEN (display TMS_REC) - ELSE (display base(?) table).
Though, I don't understand what is a "base table"; you created the TMS_REC table which is also in the database, but - somehow - I think that "base" and "database" don't mean the same for you.
What kind of help do you expect? What did you do so far? Is there any particular problem?
|
|
|