Skip to forum content
My Visual Database
A Simple Solution for Creating Databases
You are not logged in. Please login or register.
Active topics Unanswered topics
Search options (Page 2 of 2)
Version: 6.5 (04 February 2021) during time of purchase
I downloaded 6.6 beta from forum.
To download new latest versions do I have to buy life time license ?
like version 2022,2023,2024?
Priority technical support on our forum? who is providing this?
Not sure on this if there is a way to do add column
Or calculated field.
Working with this very small project and learning.
attached project is iteration of 4th revision. and now I am doing chunks only. and lot of normalization.
from 16 tables to 5 tables. (that was fun - 32 forms)
I need help with populating column.
image is in zip file what I am trying to do.
Thanks in advance.
which method is better
to reduce stock
Inward table (takes inward bill and add to stock)
Outward table(Outward gives bills to client and reduce stock)
Stock Table(have current stock details)
Transection Table(stores all transection ids)
What I can think of
method 1
update stock table using sql when sell/outward happens
task 1 - current stock = old stock - sold stock (sql to update stock table)
task 2 - stop stock value go under negative.(safe guard)
method 2
task 1 - undate sql stock table(calculated field may be) = inward table stock column - outward table stock column
task 2 - stop stock go in negative (how to lock this in database?)
thanks regards
FastScript for FastReport and Object Pascal for MVD Script form and its elements right?
or FastScript for everything?
which language? any books on language?
k245 wrote:kavinacomputers wrote:thank you sir that worked and I now understood that. Is there a way to do change other textboxes when I select something from combo box without code.
I'm sorry, but you'll have to write a script for this.
I guess
1>Customer Invoice - under database applications
2> ???
thanks
Physical to digital
what I am trying to do
I have small computer shop
I buy Items ---> goes into stock
I sell Items ---> deduction from stock(stock location)/bill the client ---> print, email
I sell Service -->Bill the client.--> print, email
bill clients ---> service or Item (provide discount if possible)
of course add taxes in bills
To track total invested in business
financial tracking
who paid on which date (closing of transection)
if not paid reminder(managing this with Samsung notes)
to whom and how much I owe dealer (open transection)
profit and loss.
I manage these with books.
How to approach invoice/bill and add it into inventory(like one bill no and add multiple entries)
stock/restock inventory
If one of you have made something into past or some example module all will be helpful.
thanks and best regards
thank you sir that worked and I now understood that. Is there a way to do change other textboxes when I select something from combo box without code.
How I can do relation management In combobox like parent child. Select country and select States(auto fill) and select states. Which again populate pincode combobox and other elements (like text box). Using no code.
New here so any help all good.
Posts found: 26 to 34 of 34