Multiple Choice

[MoGrace]

Re: Multiple Choice

Sorry..
The form was based on the set of album and song dbs (albumsongs.set)
The fields on the CDInfo tab are from the album table (album.dbf)
The Browse view primary table is songs.dbf and fields on the Fav tab are from the song table (songs.dbf)
The Browse view primary table is album.dfb and fields on the Associated Albums tab are from the albums table (album.dbf)

HTH

Just to be sure - did you specify the child table for the FAVS browse?

[Scott_S]

Re: Multiple Choice

Quote:
Originally Posted by Scott_S View Post
Sorry..
The form was based on the set of album and song dbs (albumsongs.set)
The fields on the CDInfo tab are from the album table (album.dbf)
The Browse view primary table is songs.dbf and fields on the Fav tab are from the song table (songs.dbf)
The Browse view primary table is album.dfb and fields on the Associated Albums tab are from the albums table (album.dbf)


Scott,
I believe we have some language problems going on and some problems with compleness of description happening.
Agreed...if only I knew Alpha better so that im on the same level as everyone

I'm not completely certain what your meaning with the term "primary table".
When on the entry form and you select the browse object window on one of the tabs.
If you right click on the browse object window and select properties/setup tab/ under object description, it says there what the primary table is..

In your set, the parent table I am going to assume is ALBUM table and the child table is SONGS. These are linked in 1:M through the catalog number field ( or equivalent) in both tables.
Correct
Dont know if it matters but my Parent key for the Album Table is called 'Catalog_Number' and for the Songs Table is called 'Cat_Num'

Your form has three tabs, one displaying record(s) from the parent table (album), the second displaying records from the child table (songs), and the third displaying records from the parent table (album). UNDERSTAND THIS!!!
Yes.
Tab1 shows General Album info..Artist - Title - Genre - Format - etc ...(only one album shown at a time, all fields are 'Type in Fields'
Tab2 should show the songs or favorites associated with the record shown on tab1. (But doesnt)
Tab3 shows ALL albums associated with the Aritist shown in tab1 (Which it does)

The third tab will not show records different than the first tab since they are both viewing records from the same table under the same table open session unless you refilter the records. Then the first tab will show the records that the third tab will show. UNLESS you have a second instance of the parent table in your set and have the third tab browse viewing that. You wrote:
Im only viewing one record on Tab1 as all fields are 'type in field' fields
Unless im going about it wrong..My issue is not with the Tab3 its with Tab2.
Tab3 does what should and shows all the albums associated with the artist. -"ONTABCHANGE" script below was used for this tab. Do I not need it?
I need Tab2 to just show the songs/favorites related to the record show in tab1 (currently if I pick a different album from the same artist and go to the favs tab then those songs/favorites dont change with the album

My script run from the "ONTABCHANGE" is
Open Form - ENTRY
Records that match the value in a control on the current form
...value in field ..artist_group_name
...Matches value in control ...group_or_artist_name
Are you saying I dont need this script to show the records on the Tab3

You don't mention what the ENTRY form is, what table/set it is based upon, whether this is the same as the tabbed form that you have been describing.....
From post above...."The form was based on the set of album and song dbs (albumsongs.set)" and yes the tabs are on this form

[Scott_S]

Re: Multiple Choice

Just to be sure - did you specify the child table for the FAVS browse?

Yes..
Guess I need to find a screen capture program so I can post some screen shots.

[MikeC]

Re: Multiple Choice

Scott,
If you are using Windows then hit the "Print Screen" button on your keyboard, open up Microsoft Paint, press Control+V. Then you can use the selection rectangle box to copy any part of the image.....not a one-step procedure as third party software but works. Save generally as a PNG (seems best) or a JPG (JPEG) file.

[Mike Wilson]

Re: Multiple Choice

BUT why not zip a copy of your app and post it so we can see it and stop all this trying to piece little inputs? I'm about done...

[Scott_S]

Re: Multiple Choice

Here ya go!

[Mike Wilson]

Re: Multiple Choice

OK Scott,
We have your example, now lets get to what exactly you want. There are several albums but very few songs. The tab1 and tab3 will show the table with all the same records available for viewing. It's just that tab1 will show one record at a time because it is a form view and tab 3 all the records because it is a browse view. So what exactly are you expecting/wishing to happen and viewed? An example like:

"I want to be viewing ALBUMN Sammy Hagar- "I never said goodbye" in tab1. The SONGS I expect to see in tab2 are x,y, and z because this, that , the other. In tab3 I expect to see ALL of the Sammy Hagar albums in the collection since I have Sammy Hagar as the selected artist in tab1."

Tag, your it....

[Scott_S]

Re: Multiple Choice

OK Scott,
We have your example, now lets get to what exactly you want. There are several albums but very few songs. The tab1 and tab3 will show the table with all the same records available for viewing. It's just that tab1 will show one record at a time because it is a form view and tab 3 all the records because it is a browse view. So what exactly are you expecting/wishing to happen and viewed? An example like:

"I want to be viewing ALBUMN Sammy Hagar- "I never said goodbye" in tab1. The SONGS I expect to see in tab2 are x,y, and z because this, that , the other. In tab3 I expect to see ALL of the Sammy Hagar albums in the collection since I have Sammy Hagar as the selected artist in tab1."

Tag, your it....

Several Albums and not all complete or accurate as I'm learning alpha. Guess I was more concerned in getting the internal workings of the program to work for me first before getting to involved with entering too much data.
Few songs because well, this was the original reason for this thread, to be able to mark my favorite songs.
My original thought was just to have a bunch of checkmark fields next to some track numbers so that I could mark the tracks I wanted. But things have drifted towards having a songdb. Plus dealing with the issue that not every Album has the same amount of songs and some albums are 'dual disk'.

"I want to be viewing ALBUMN Sammy Hagar- "I never said goodbye" in tab1. The SONGS I expect to see in tab2 are x,y, and z because this, that , the other. In tab3 I expect to see ALL of the Sammy Hagar albums in the collection since I have Sammy Hagar as the selected artist in tab1."

Yes you are correct.
Tab1. Single record view
Tab2. Songs that are related to the the record in Tab1 (if the next Album is another Sammy Hagar album "3 Lock Box" then Tab2 should reflect the change and show the songs from that album)
Tab3. All Albums that are related to the current Artist in Tab1

[Mike Wilson]

Re: Multiple Choice

OK,
Given that, you need to add a second instance of the album table to the set and have that viewed by the browse in tab3. I'll work it up and post it back here when complete.

[Tim Kiebert]

Re: Multiple Choice

In the attached sample the set has been edited to include the Album table as a child of itself linked on the Artist_group_name field. (As per Mike's suggestion) In the Music_Entry form the browse on the third tab is now based on the Album1 alias of the set. The code on the tabchange events has been removed.


In response to the original question in the attached sample is a form called Music_Favs. The form is based on only the Album table. The form has twenty Fav buttons. The visible property of each button is dynamic and is based on the track count. The fill color is also dynamic and is based on the corresponding number being present in the 'Favs' field. The 'Favs' field is a new field added to the Album table. Pushing a button will either add or remove the corresponding number from the Favs field. The numbers are stored in a space delimited format: ie "01 02 05 12". The work of adding and subtracting the data is done by the 'Set_favs' UDF and is done through a field object on the form which is hidden. This allows for any changes to the favourites to be done at the form level and changes can be saved or canceled in the same way as any other form field.

There is also a more titles button to show additional titles by the same artist. The popup is an xdialog with an embedded browse. To close it click anywhere outside the browse. Double clicking a row will find that song in the main form.

[Scott_S]

Re: Multiple Choice

Mike, Tim,

Created the second instance of the album table and set the browse for the correct table. Works great.

Tim,
I've been looking at your sample db and clicking on 'more titles' brings up
a alpha error box which reads
Script UI_MODELESS_DLG_BOX: Additional Titles line 6
Browseobj1 = a5_xdialogDefaultBrowse(dlg_title,"browsecard_browseobj1", b function is not recognized.

also when checking the 'showfavfield' is this suppose to bring up another view?

[MikeC]

Re: Multiple Choice

Scott,
Tim inadvertantly used a new function that appeared only since v9 so cannot be used in the v8 you have..... Ooops! :)

[Tim Kiebert]

Re: Multiple Choice

Uhmmmm, yehhh, OOPS. My bad. :o

Actually that whole form probably won't work as it uses the new dynamic properties of v10.

I will try to rework it for v8

[Scott_S]

Re: Multiple Choice

Uhmmmm, yehhh, OOPS. My bad. :o

Actually that whole form probably won't work as it uses the new dynamic properties of v10.

I will try to rework it for v8

Ok thanks...

Few more questions if I may

1. Album tab vs Favorites tab - why am I able to adjust the sizing of the row of the browse on the album tab but unable to on the favorites tab?

I've reduced the height of the rows on the albums tab browse but when I do so on the favorites tab browse it goes back to a different size then what I adjusted it to?


2. Lets say I have a cd that is a tribute album to a certain group. I would like a way to associate it with the original group.
So thought I would use a 'sort by' field.

So data would get entered as such
Artist: XYZ
Title: Rock on
Sort By: AC/DC

Then if I select AC/DC for the associated albums tab, it would show XYZ / Rock on, along with other AC/DC albums in the browse or reports.
would this be possible?