I have admin site and dealer site....
Dealer can only transaction of stock. and show the summery of own record.
In the selling table there is not to store dealer id in "selling" table there is a dealer_stock_id come from "dealer stock" table. and Dealer stock table in which "dealer id" stored.
dealer table
===========
-dealer_id
- dealer_name
-dealer_address
-dealer_username
-dealer_password
Dealer_stock
=============
- de_stock_id
-de_cat_id
- de_prod_id
- de_att_id
- de_stock_dealer_id [F; dealer_id]
-
Selling
======
selling_id
sell_dealer_stock_id [f: dealer_stock]
seller_name
sell_qty
sell_entry date.
As per above table structure, when any dealer logged in and i want to show that record which belong to logged in user.
sell_dealer_stock_id-> relate to -> de_stock_id -> from that get the dealer id.
such dealer id matched with where clause and show record ?
how help me?
thankx in advance....
sorry for poor english.