Can i turn a Form Into a form from a set?

[Digitaled]

I am re working some things and i have a very full form created from a table.

I now need this form to work with a Table set.

Can i some how change the Form from a table into a form from a set.
The same main table will be used i just need to add in fields from other tables into to this one.

I would hate to have to re-build this form from the new Table set i made.

Thanks

[Raymond Lyons]

Re: Can i turn a Form Into a form from a set?

Right click on the form in the control panel and click "Copy to..." and copy it to the set.

Ray

[Digitaled]

Re: Can i turn a Form Into a form from a set?

Right click on the form in the control panel and click "Copy to..." and copy it to the set.

Ray

Thank you ..Thank you ..Thank you
That just saved me a days worth of work...

[Digitaled]

Re: Can i turn a Form Into a form from a set?

OOH it will not work.

I am trying to copy a copy of the Alpha sports customers form into a set.
It did move it into the set but when it did this the Search By no longer works.
That's what i need is the Search by.


I now get a

Script:OnInit line:10
tbl.order(vcSearchby,".t.")
No such field

[Stan Mathews]

Re: Can i turn a Form Into a form from a set?

OOH it will not work.

I am trying to copy a copy of the Alpha sports customers form into a set.
It did move it into the set but when it did this the Search By no longer works.
That's what i need is the Search by.


I now get a

Script:OnInit line:10
tbl.order(vcSearchby,".t.")
No such field

The oninit event for the AlphaSports customer information form is hard coded to use a default initial value for vcSearchby of "Lastname".

dim shared vcSearchby as c 
[B]vcSearchby = "Lastname"[/B]

dim tbl as p 
tbl = table.current()
tbl.order(vcSearchby,".t.")

If you don't have a field "lastname", change that line of code to reflect what you desire as the initial search term.

[Digitaled]

Re: Can i turn a Form Into a form from a set?

Hi i am having another problem now.

I was going to try what you posted but now every time i click on the copy to buttom Alpha closes down??

It dose not matter what form i try it will close Alpha down.

[Digitaled]

Re: Can i turn a Form Into a form from a set?

Ok i got it back up working and i created another copy of the customer form and saved it into a set.

The set has the customer information in it and the form is a copy of the original and has all the same fields in it nothing has chenged except it is part of a set now.

It still will not work.

??

Here is the code it shows

'Date Created: 11-Jul-2002 10:07:42 PM
'Last Updated: 26-Jan-2007 09:21:17 PM
'Created By :
'Updated By : Digitaled
'set the column heading of the browse object to be the same as the entry selected in the combo box.
topparent:Browse1:Lastname.Object.Column_title = searchby.text

'Set the width of the column in the browse to 30 (it will have gotten set to a smaller value when the SearchBy variable was changed)
Browse1:Lastname.Entry.Width = 30



'now sort table by the field that was selected
dim tbl as p
tbl = table.current()
tbl.order(searchby.text,searchby.text + " <> \"\"")

'move the record pointer to the first record in the table
tbl.fetch_first()


mulstbtn1.text = "1" '' I chose '1' because it is not in the set A-Z that we display

'resynchronize the form with the data in the underlying table
topparent.resynch()