Tabbed forms

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I currently have a field called customer problem in which i record data about
their related machines.
When a customer first reports a problem is it possible to save and update so
that this field now becomes blank and it saves the new record into a tabbed
control within a form as a new record i.e. past problems
Any advice would be much appreciated
Matt
 
Matt said:
I currently have a field called customer problem in which i record
data about their related machines.
When a customer first reports a problem is it possible to save and
update so that this field now becomes blank and it saves the new
record into a tabbed control within a form as a new record i.e. past
problems
Any advice would be much appreciated
Matt
Click to expand...

You need (at least) two tables. One for customers and one for problems. These
have a one-to-many relationship because each customer can have multiple
problems. You would then use a form for Customers with a subform for problems.
Each problem is now a separate record in the problem table and if you sort the
Recordset for the form in descending order on ProblemDate or an incrementing
ProblemID then you will automatically see the newest problem first when viewing
it.

(the subform could be placed on a TabControl page).
 
Back
Top