Recent content by reb0101

Hey guys, I’m going to throw this out here in hopes someone may be able to shed some light on this. Have an Access form with essentially 4 fields ASM Certification MPR Certification (Combo Box ) TMS (Combo Box ) QUAL Type Two, as you can see are combo box. There are some other filters...

hey all, I'm back to banging my head against the wall on an entirely different issue, the elusive ListView. Let me tell you what I have, and works, and what I'm hoping for, not working yet. Shipping Database that seems to never be complete. REGION TABLE: REG_ID (PK Autonumber) SELECT...

JHB and nanscombe, Yes it works, or for the most part. It was pulling the correct data into Carrier but it was not displaying, could not see it. So got that solved and moved on. The next problem that I ran into was having the form that the cascading combo boxes on was bound to a table. All kinds...

BINGO ! Thank you Nigel and thank you JHB. I just tried it and it shows up but still need to work with enabling it after Port Selected. Again, thank you both !

yes, just saw it. If I change from Column Count 2 to 1, then I get nothing. Before, it was working from code JHB gave me and I could tell by selecting a CARRIER and it show up in the table. But I could not see the value in the combo box, it was there, but you could not see it. I believe screen...

I'm about a day away from Filemaker PRO! So I finally get the cascading combo boxes to work, the last step to get the final one to pull from a Junction table courtesy of JHB even though the last box seems a little shy and doesn't want to show itself, but first things first. The goal here is to...

JHB, as far as the test data, just about to post that ....5 minutes.

JHB, turns out you were right. It worked for me, just can't 'see' it. Can't figure that one out for the life of me but now trying to get the selected values into another table.

Thank you Mihail, I'll zip and attach where I got before I more on to the more frustrating issue of cascading combo boxes with junction tables and having text boxes display selected data that apparently won't display as text (and displays as ID number) unless you change them to a combo box. I'm...

JHB, thanks for the effort but it didn't work. Before it was giving me the id numbers, now it's just blank when I click teh combo box, it's like the values are there but not displayed. Then oddly enough, when I try and close the form I get a Parameter Query msg box with the name of a carrier, in...

Mihail, Don't bother with the mileage rates, they are as you said incorrect with lots of duplicates and other errors. I was given a spreadsheet with a lot of tabs and over 8K records, Mileage Rates was just one of those tabs. my 'task', if you want to call it that is to go through this scattered...

thanks Mihail, In America and so a few hours behind Romania. Going to get some sleep and will check in first thing in the morning

hey all, I have either given up or taken a break, not sure with on table / relationship structure with considerable help from both gemma-the-husky and Mihail. Thank you both as much for your patience as technical help. I'm jumping to the forms development and going to try what I need via...

hello Mihail thanks for your reply, I will try and answer your questions. Except one more thing: From this sheet I don't understand that the rate depend from CARRIER. I see this in your SAMPLE DATA. Have I understand OK ? (The rate depend from the carrier, distance and unit) The data was...

jdraw and spikepl, thank you both for the quick replies. I'll try and explain with more clarity and steer clear of the DB-speak and keep it on a level of more what I am trying to achieve here. I could very well have the entire table structure wrong here to begin with, so I'll explain without...