|
| I would like to have some sort of a multi insert form on which I'd be
able to select amongst each of the filtered parts of one table (file).
This was a bad explanation so I'll try like this:
I have a PCConfiguration table and a Components table with all of my
components inside (one to many relationship, respectively) . Each
component has a variable that defines what type of component it is
(e.g. CPU, MBO, soundcard, monitor,...). Using this variable I was
able to create views in MSSQL (all of the tables/files are on MSSQL)
that filter Components. I've imported the views in dct. (Most likely I
didn't have to do the views thing because there's a way to do the
filtering in Clarion but I just don't know how).
My problem is that I (also) don't know how to place all of these views
on a form and to ad one by one filtered components.
It doesn't have to be one form, it could be a popup forms for each of
the component types.
Thirdly, I'd like to know how to insert into the Components(fields are
ComponentID, ComponentName...) record the viewID as its own (to place
the viewID as a ComponentID, because view table is basically a part of
a Component table) once the view record is selected (guess i wouldn't
have this problem if i knew to filter Components in Clarion, also).
Any help is greatly appreciated.
Mate Boban
|
|