Want search form to initially to be blank
Posted: Tue Feb 09, 2021 7:08 am
Im New to nuBuilder. Have been reading the documentation. (Not written for newbies) and have watched several videos. (Moves way too fast and doesn't really explain details - too many assumptions). Have read the wikis (Not much useful) and looked at all the Pizzas.
So Far Ive accomplished creating a customer table, with a simple lookup table (i guess in nuB terms its called a Select not a Lookup) on the State field. (couldn't import a csv list of state names and abbreviations, because of the self imposed States_Id field that nuB automatically added to the States table). Had to manually enter the States info. I've also managed to use the Fast Forms, format some fields, arrange them( finally figured out where to get to the arrange function - not in manuls), manually changed the CSS to adjust the fonts on input fields and labels (woefully lacking), but still have a few questions.
Since this is tagged as Better than Access (??? - implementing "lookup" fields alone is a struggle here...) here are a few simple things that can be done in access that seem to be like pulling hairs out to accomplish here:
1. Lookup fields or Select field - I still not sure what you intend a "lookup" field to be and how it differs from a select field, except in maybe the way it pulls in data via the SQL statement. The videos nor the manual do a good job at explaining this concept. Case in point adding a simple lookup table on my State Field in my Customer Table, was nothing short of an educated guess and trial and error. Even the SQL statement I used to get the data I wanted (from two fields, the state abbreviation and state name, ie: AZ for Arizona. This doesn't really make sense how the nuB imposed ID field comes into play. (NOTE: My next form has about 10 lookup (select) fields, and I have NO idea how im going to get all those linked. In Access this is point and click easy to do and I fully understand that nuB has much greater flexibiilty and functionality, but the manuals/videos/wikis really need to do a much better job.
2. The "Search Form" For my customer table, that I used Fast Forms Builder to create, Im trying to figure out how to make my search form NOT automatically display all my records (the auto generated SQL statement that says "Select * from customer" is whats causing this. But I can seem to change this or leave it blank, because then my actual search doesn't work. So whats the point of having the SQL even on the search form properties under browse, if it cant be changed? I simply want to be able to come into to search and have no records displayed until I actually type something in the search box and click search. OR another neat feature would be the ability to incorporate an active search as a I type in characters in the fields. I've done this elsewhere by writing my own PHP code to accomplish it. Here is a link on how to accomplish it. https://www.w3schools.com/php/php_ajax_livesearch.asp Any ideas how to make the search blank initially until I actually click search would be greatly helpful.
After searching for my "Customer" and selecting them on the search form and it opens the Edit form, how do i: 1. Make this a NON-Editable form, until I actually click a button or something to allow me to edit the fields, EXCEPT the priamry search field, (ie: the persons SSN)? 2. Include a list of records from another table (orders) that this customer has previously created, IE: kind of like a search form embedded in the customer details form. (DO I use a subform and link that to a search form for the orders table? IF so, the same applies. When I click the order number, I don't want to be in an edit mode, unless I click a button to do so. Like this:
=====================
Customer Info details form:
SSN, Name
Address, City, State Zip
Phone1 Phone2 etc...
=====================
Orders:
ordernum1 orderdate Totamount1
ordernum2 orderdate Totamount2
ordernum3 orderdate Totamount3
=====================
Then If I click on ordernum1 a new form (non-editable) opens up with the Customer Info detail and the Order Details...unless I click an edit button.
Any ideas how to accomplish this and/or at least point me in the right direction (besides watch video / read manual) would be greatly helpful. I think Once I get past these two hurdles I'll be heading in the right direction...
Thanks for any guidance you might provide....
So Far Ive accomplished creating a customer table, with a simple lookup table (i guess in nuB terms its called a Select not a Lookup) on the State field. (couldn't import a csv list of state names and abbreviations, because of the self imposed States_Id field that nuB automatically added to the States table). Had to manually enter the States info. I've also managed to use the Fast Forms, format some fields, arrange them( finally figured out where to get to the arrange function - not in manuls), manually changed the CSS to adjust the fonts on input fields and labels (woefully lacking), but still have a few questions.
Since this is tagged as Better than Access (??? - implementing "lookup" fields alone is a struggle here...) here are a few simple things that can be done in access that seem to be like pulling hairs out to accomplish here:
1. Lookup fields or Select field - I still not sure what you intend a "lookup" field to be and how it differs from a select field, except in maybe the way it pulls in data via the SQL statement. The videos nor the manual do a good job at explaining this concept. Case in point adding a simple lookup table on my State Field in my Customer Table, was nothing short of an educated guess and trial and error. Even the SQL statement I used to get the data I wanted (from two fields, the state abbreviation and state name, ie: AZ for Arizona. This doesn't really make sense how the nuB imposed ID field comes into play. (NOTE: My next form has about 10 lookup (select) fields, and I have NO idea how im going to get all those linked. In Access this is point and click easy to do and I fully understand that nuB has much greater flexibiilty and functionality, but the manuals/videos/wikis really need to do a much better job.
2. The "Search Form" For my customer table, that I used Fast Forms Builder to create, Im trying to figure out how to make my search form NOT automatically display all my records (the auto generated SQL statement that says "Select * from customer" is whats causing this. But I can seem to change this or leave it blank, because then my actual search doesn't work. So whats the point of having the SQL even on the search form properties under browse, if it cant be changed? I simply want to be able to come into to search and have no records displayed until I actually type something in the search box and click search. OR another neat feature would be the ability to incorporate an active search as a I type in characters in the fields. I've done this elsewhere by writing my own PHP code to accomplish it. Here is a link on how to accomplish it. https://www.w3schools.com/php/php_ajax_livesearch.asp Any ideas how to make the search blank initially until I actually click search would be greatly helpful.
After searching for my "Customer" and selecting them on the search form and it opens the Edit form, how do i: 1. Make this a NON-Editable form, until I actually click a button or something to allow me to edit the fields, EXCEPT the priamry search field, (ie: the persons SSN)? 2. Include a list of records from another table (orders) that this customer has previously created, IE: kind of like a search form embedded in the customer details form. (DO I use a subform and link that to a search form for the orders table? IF so, the same applies. When I click the order number, I don't want to be in an edit mode, unless I click a button to do so. Like this:
=====================
Customer Info details form:
SSN, Name
Address, City, State Zip
Phone1 Phone2 etc...
=====================
Orders:
ordernum1 orderdate Totamount1
ordernum2 orderdate Totamount2
ordernum3 orderdate Totamount3
=====================
Then If I click on ordernum1 a new form (non-editable) opens up with the Customer Info detail and the Order Details...unless I click an edit button.
Any ideas how to accomplish this and/or at least point me in the right direction (besides watch video / read manual) would be greatly helpful. I think Once I get past these two hurdles I'll be heading in the right direction...
Thanks for any guidance you might provide....