relationship for listbox

[jspellman]

I have a form. It has po top information. I created a list box. of the detailed information. However, the information in the list box displays all the records in the po line information. I want to set a relationship to allow for only the information with the same po number to be reflected in the list box. Is this possible. Any help would be appreciated.

Thanks,

John

 

[Mike Gagnon]

jspellman

Is the relationship set in the dataenvironment of the form? Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first

 

[jspellman]

I am kind of new to relationships. In the data environment of the form there is a relationship. However it still shows all records.

Thanks,

John

 

[Mike Gagnon]

jspellman

The short term solution would be to set a filter on the current P.O. number for your listbox. Although I would recommend you use a grid (that you can make it look like a listbox), and at least you have settings for one-to-many relationships. Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first

 

[jspellman]

Mike,

I have used a grid. It works like I want. However, it can still be edited. is there a way to not allow this. is it as simple as deactivating the object?

Thanks

 

[Mike Gagnon]

I have used a grid. It works like I want. However, it can still be edited. is there a way to not allow this. is it as simple as deactivating the object?

Set the grid's read-only to .T.


Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first

 

[jspellman]

great thanks for the help. Knew I was forgetting something.